Sectional run in Zoho DataPrep

Pipeline sectional run

When data propagation happens in a pipeline, the changes made in the upstream stages are loaded to the current stage that you're working on. This runs a section of a pipeline and therefore called Sectional runs.

What is data propagation?

Data propagation is the process of loading any changes made in the upstream stages to the current stage that you're working on. Let's say you make some changes rule additions or edits in a parent stage(s), those changes will be propagated to the dependent child stage(s). 

In DataPrep, data propagation is processed either manually or automatically based on your preference in the Settings tab. Learn more about data propagation. 

Notes
Note: Auto or manual data propagation where changes are loaded from the upstream are counted towards rows processed consumption.

To execute sectional run in a pipeline 


1. Open your pipeline and go to the pipeline builder view. Click here if you want to know how to create a pipeline in the first place.

2. Click on the Add data option to bring your data from the required data source. Learn more on 50+ data sources.

After data is imported, you will be redirected to the pipeline builder where you can see your data source, and a stage linked to it.

Stages are nodes created for processing data while applying data flow transforms. Every dataset imported from your data source will have a stage created by default.

3. You can right-click the stage and apply the data flow transforms.

4. You can also choose to Prepare Data to open the DataPrep Studio page and explore more data transformsClick here to know the various elements in a pipeline builder.

Trigger sectional run

A sectional run is automatically triggered when data propagation happens in a pipeline and doesn't require a manual trigger. Let's look into the below example to understand this.

Example

5. I have Leads data in the first stage. Now I would like to view the leads generated during the first quarter and create a report. But I would still need all data later for future. So I'm going to create another stage from my current stage. This will create a copy of my current stage. To do this, right-click on the stage and choose the Add stage option. A new child stage gets created. In the child stage, you can filter the required data using the Filters transform



6. Now I have made some updates in the contact information for a few leads in the parent stage and would like the same changes in the child stage. 

7. Open the child stage and you will find the below screen if you had enabled the Preferences toggle in the Settings tab. The data changes from the upstream will start propagating automatically. 




Notes
Note: If you had disabled the Preferences toggle in the Settings tab, you will see the below pop-up and the sectional run will be triggered when you propagate data manually.



8. This will initiate the sectional run and execute the pipeline. To view the run details, go to the Job history page and enable the Include Sectional Jobs toggle. This will show the list of sectional runs. 



You can click open specific jobs to view more details such as start and end time, duration of the job, etc.  in the Jobs summary page. The Job summary shows the history of a job executed in a pipeline flow. Click here to know more about Jobs and Job summary.  You can view the status of the run on the Job summary page. There are three different status for a job in DataPrep - Initiated, Success and Failure. 
To export data, you can right-click a stage, add a destination and run the pipeline. Here's the different types of runs in DataPrep

In the Overview tab, you can view the status of the job along with the details such as user who started the job, storage used, total rows processed, start time, end time and duration of the job. Click here to know more.



In the Stages tab, you can view the details of each pipeline stage such as Import, Transform and Export. Click here to know more.


9. Once you are done updating your data, you can go back to the Pipeline builder page, right-click a stage and add a destination. 

Data destination is a place where you want to export your data to. It can be your local database, business applications like Zoho CRM, Zoho Analytics, etc. You can choose your preferred destination out of 50+ data destinations in DataPrep to export your prepared data


10. After adding a destination for your pipeline, click the Run drop down and choose a run type and execute the pipeline. Runs types in DataPrep.

Idea
Important: A sectional run will not export data to your destination. Please make sure to manually run the pipeline to get your data exported.

      Create. Review. Publish.

      Write, edit, collaborate on, and publish documents to different content management platforms.

      Get Started Now


        Access your files securely from anywhere

          Zoho CRM Training Programs

          Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

          Zoho CRM Training
            Redefine the way you work
            with Zoho Workplace

              Zoho DataPrep Personalized Demo

              If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

              Zoho CRM Training

                Create, share, and deliver

                beautiful slides from anywhere.

                Get Started Now


                  Zoho Sign now offers specialized one-on-one training for both administrators and developers.

                  BOOK A SESSION







                              Quick LinksWorkflow AutomationData Collection
                              Web FormsEnterpriseOnline Data Collection Tool
                              Embeddable FormsBankingBegin Data Collection
                              Interactive FormsWorkplaceData Collection App
                              CRM FormsCustomer ServiceAccessible Forms
                              Digital FormsMarketingForms for Small Business
                              HTML FormsEducationForms for Enterprise
                              Contact FormsE-commerceForms for any business
                              Lead Generation FormsHealthcareForms for Startups
                              Wordpress FormsCustomer onboardingForms for Small Business
                              No Code FormsConstructionRSVP tool for holidays
                              Free FormsTravelFeatures for Order Forms
                              Prefill FormsNon-Profit
                              Intake FormsLegalMobile App
                              Form DesignerHRMobile Forms
                              Card FormsFoodOffline Forms
                              Assign FormsPhotographyMobile Forms Features
                              Translate FormsReal EstateKiosk in Mobile Forms
                              Electronic Forms
                              Drag & drop form builder

                              Notification Emails for FormsAlternativesSecurity & Compliance
                              Holiday FormsGoogle Forms alternative GDPR
                              Form to PDFJotform alternativeHIPAA Forms
                              Email FormsEncrypted Forms

                              Secure Forms

                              WCAG

                                      Create. Review. Publish.

                                      Write, edit, collaborate on, and publish documents to different content management platforms.

                                      Get Started Now






                                                        You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                                            Manage your brands on social media

                                                              Use cases

                                                              Make the most of Zoho Desk with the use cases.

                                                               
                                                                

                                                              eBooks

                                                              Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho Desk.

                                                               
                                                                

                                                              Videos

                                                              Watch comprehensive videos on features and other important topics that will help you master Zoho Desk.

                                                               
                                                                

                                                              Webinar

                                                              Sign up for our webinars and learn the Zoho Desk basics, from customization to automation and more

                                                               
                                                                
                                                              • Desk Community Learning Series


                                                              • Meetups


                                                              • Ask the Experts


                                                              • Kbase


                                                              • Resources


                                                              • Glossary


                                                              • Desk Marketplace


                                                              • MVP Corner

                                                                Zoho Sheet Resources

                                                                 

                                                                    Zoho Forms Resources


                                                                      Secure your business
                                                                      communication with Zoho Mail


                                                                      Mail on the move with
                                                                      Zoho Mail mobile application

                                                                        Stay on top of your schedule
                                                                        at all times


                                                                        Carry your calendar with you
                                                                        Anytime, anywhere




                                                                              Zoho Sign Resources

                                                                                Sign, Paperless!

                                                                                Sign and send business documents on the go!

                                                                                Get Started Now




                                                                                        Zoho TeamInbox Resources





                                                                                                  Zoho DataPrep Demo

                                                                                                  Get a personalized demo or POC

                                                                                                  REGISTER NOW


                                                                                                    Design. Discuss. Deliver.

                                                                                                    Create visually engaging stories with Zoho Show.

                                                                                                    Get Started Now









                                                                                                                        • Related Articles

                                                                                                                        • Pipeline Manual run

                                                                                                                          By triggering the manual run option in your pipeline, you can export the data you have prepared to your destination. A manual run will run your pipeline on the existing data without refreshing, which means no new data will be imported. Note: You can ...
                                                                                                                        • Pipeline Backfill run

                                                                                                                          Backfill run can process data that was missed in previous schedules due to a change in data models or data preparation workflow. This way, you can catch up with missed schedules or if you want to import specific data within a timeframe data, or to ...
                                                                                                                        • Pipeline

                                                                                                                          Pipelines are fundamental entities that allows users to create data flows in DataPrep, with multiple data stages and various flow level transforms. To view the list of pipelines, you can click the Pipeline tab from the top bar. The Pipelines tab ...
                                                                                                                        • Create a new pipeline

                                                                                                                          Pipelines are fundamental entities that allows users to create data flows in DataPrep, with multiple data stages and using various flow level transforms. You can create a new pipeline from scratch from the below places. Home page Pipelines tab ...
                                                                                                                        • Create pipeline from template library

                                                                                                                          Pipelines are fundamental entities that allows users to create data flows in DataPrep, with multiple data stages and various flow level transforms. Template library is a place which contains pre-defined templates and all the saved pipeline templates. ...
                                                                                                                          Wherever you are is as good as
                                                                                                                          your workplace

                                                                                                                            Resources

                                                                                                                            Videos

                                                                                                                            Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                                            eBooks

                                                                                                                            Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                                            Webinars

                                                                                                                            Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                                            CRM Tips

                                                                                                                            Make the most of Zoho CRM with these useful tips.



                                                                                                                              Zoho Show Resources