How to use one single variable in many Export Datasets? (4221404)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

How to use one single variable in many Export Datasets?
Description

How can one declare one single variable and use it in many subsequent activities?
For example, when creating many monthly reports, "Export Dataset", in one Automation Script, all of them using the same value in their queries to make sure that the queries only retrieve data from the wanted month, if one wants to:
1. - Declare a variable.
2. - Set it to have the value related to the wanted month.
3. - Use it in all the subsequent queries?
How can this be done?
Resolution

1. - Go to the "Control" tab, create a "Create Variable" action, and set it as a Global Variable.
2. - In the Export Dataset action, go to the "Dataset" tab, and after making sure that the query invokes a variable by using the ":" symbol, click on the "Set Variables" button and look for the variable created in the STEP_1 in the "Environmet Variable" list.
3. - Repeat STEP_2 for all the Export Dataset actions in the Script.