I want to change the variable value based on the value change in another variable.
eg- I have conditional load-
if vSource = EMP then vFileName = Employee Data_12345.xlsx
if vSource = ORG then vFileName = Organisation Data_09876.xlsx
I want to put vFileName in the from statement, instead of hardcoding the filename.
Similarly the few FIELD NAMES in each source may change in future, so i want to put the field names of each excel source in variableS and show all variables in UI, so we can have a glance and if required change the field names in the variables. So the new set of field variables value should also be controlled based on value in vSource variable.