Hello!
I am trying to create an Analytic app that prompts the user to choose 4 files, and for each file, decide which of the fields will be the ID field.
Right now, I have the actions to select the data and select the field from the data, but how can I change the "ID" field to be whatever field is chosen?
Originally, I wanted to use the mapping functionality on the data input, but I couldn't figure out how to only map 1 column and just pull in the rest. I want the output of this specific file to have all of the columns and to either rename their specified ID field to be ID OR to have all of the columns and an extra ID column called ID with their specified column populated. Do you think this would have been a better way of doing it/if so, how would you go about it?
Could someone please assist?
Thanks so much in advance!
