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 working on a project where i need to create an alteryx application where --
Input can be any number of excels with any number of columns but output has a template (fixed output columns )
so output will be the consolidated excel of all the input excels --
problem here is -- In the input excels column names may differ like -
for example - Employee name / name/ emp name for Employee Name in output
so i would like to fix the template at input tool (same as output) and if the input file do not follow the template -- it throws an error or any workflow to accept all the different column names and automatically convert them into the final output column name
I would recommend you to have the application to select a folder to in which all the files are together. After input all the files into a batch macro to union the data (this may only be possible if all the files have the same number of columns (name doesn't matter).