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 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.
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.
Column A , Column C , COlumn E
This is a simple approach to get what you need.
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.
Did a batch macro to read a directory of excel files with different columns/heders. Look at the workflow and if any confusion, plz ping me and I can explain.