Hi,I want to import multiple excel file( to one data input tool) with different schema and union it?I have come across multiple post which describes the method somehow I am facing issue implementing it. Here for example I have include few file.
Hello @SH_94 ,
1.- That's not like it, one control parameter adds the file name while the other specifies the file type. If you would like to add xlsb too you would just need to add the file format number on the text input on the find replace tool, thats it.
2.- To add multiple sheets you would need to change the solution like the one I just added
Regards
Regarding your questions:
The dynamic input acts as a batch macro extracting the desired data (either the information from all the excel files or the sheet names, depending on the configration). The edit button takes and a template which would be the one your files are following, you can say it acts as a dummy, informing the macro how your files will look like. Take into account, that the files need to follow the same structre as the one on the template or they will be skipped. A message as a warning will appear on the result window if this is the case).
2.- Input data can have insert data when the files either are individual or share the same name, if that is not the case, we usually use the dynamic inpt tool. This has also other uses (for DB connections replacing parts of the query for example)
3.- Since we are extracting all the sheet names, what I am doing on that formula tool is replacing the "<List of sheet names>" parameters with the actual sheet name.
4.- Within the macro you only need to add a file, and in this case an excel file. Unless you want to tinker a little bit with it, I would recommend leaving it as it is. This is a dummy file to specify what filetype will come in. You could for example replace only part of the string.
5.- I have already done that on one of the last posts you have published:
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Maintain-File-name-and-sheet-name-using-macro/td-p/736683
Hello @abhishekyx,
this should do it:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Regards
Hi @afv2688 ,
Could you guide me on how to use the macro provided? It would be great if you can show me with the screenshot on how to use the macro and things to update when using it.
Thank you.
