I have a period column which contains value like 201708,201709,201710 etc.
I have to extract the value from another file based on the current period only.
Eg. In file A I have Period columns contain 201708,201709,201710 etc. where as in file B I have entire history details and need to extract only the data for Current month. and for some related to previous month
I have created a variable as shown below
For Previous month and year variable is not working at the script level where as it is working fine in text object.
And Can anyone confirm me whether it is the right approach or not?
and will variable values in the script will change automatically when period value changes .