Hello,
I am trying to solve a problem where i am getting data from different sources and trying to copy that data at single destination based on the metadata stored in SQL table. Below are the steps I did.
1) I have 3 rest call and the output of those calls going as input to lookup activity.
2) The lookup activity is queried on SQL DB which has 3 records and pulling 2 columns only, file_name and table_name
3) The for each activity is iterating on the lookup array output and from each item i am getting the item().file_name.
4) now for each item I am trying to use Switch case to decide based on the file name what should be destination of the data.
5) I am not sure how I can use the file_name coming in step 3 to use as a case in switch activity. Can any one please guide me on that.
