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 have a template for my output and my input files may have any number of columns . is there any way or tool to set the setting to pick only the template columns from the input excel or raw data every time when the workflow is run ..
eg - my output template column is -- name | class | marks | age
and my raw data may have any number of columns together with the template columns.
how can i do the setting so that my workflow always pick the template columns automatically whenever workflow is run on new data.
The one that comes to mind is if you read in your template file - with the headers you want and with one row of nulls in all columns. You can then Union your template to your raw data file and select the option to 'Output common subset of fields'. This will union the nulls on but restrict the fields to just the ones in the template. You can then use a filter tool to remove the null values afterwards.
Let me know if this works for you or if you find a different solution.