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.
The highly anticipated Alteryx Community tradition is back! We hope you'll join us!
Learn MoreHi All,
I have the following scenario to read multiple excel tab from an excel sheet with different schema. ANy guidance would be greatly appreciated.
I understand that dynamic input is only for same schema but doesnt help in my case.
Thanks in advance.
Example
abc.xlsx
tab1 - A, B, C, D,E,F,G
tab2 - A,C,E
tab3 - A,B,C,D,E
I want to pull records from the three tabs and select ONLY column A, C , E ONLY.
Output:
Column A , Column C , COlumn E
Regards,
Vignesh
This is a simple approach to get what you need.
Hello,
I dont want to go with the brute force method which is to use multiple input. It would be tedious if i have 1000 files and use 1000 inputs tool.