This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?
Hi @lailas this link will show you how to open the file. The file attached was a packed workflow when you clicked it on it would create a folder and download the app. That is what you need to open and change the version to match yours.
I also attached a macro version of my example and back versioned to 2018.1
Hi @lailas I think I understand your problem you want to depending on the file parse the column headers into the dropdown. I don't think it will exactly as you want with using a static file as the workflow will need to run essentially first to push the column headers into the dropdown. You could do this two ways one use a chained app so bring in your file first output a file with the header names the second app would use that. Another option is to a command line to generate the file to be used in the dropdown. An alternative is you just a text input and get the user to specify the ID column.
Yes, makes sense! So if I did a text input for them to specify the ID column, how can I insert that into the name of the field? I think it would be with a formula tool, but I can't figure that out. Right now, I have a formula tool that has an update value, but it is updating it with text. I want to update it with the field name,