Hello Guys, I have a dataset with a variable called "ENVIRONMENT", the values will in it would be either "UAT" or "PROD", but not both the values. I want to store the value in a macro variable. eg. if the dataset has a value of "UAT" stored today the macro variable should resolve to "UAT". if the next extract of dataset tomorrow contains "PROD" i want the macro variable to resolve to "PROD" Can anyone please help me out?
... View more