I have a requirement in which I want to bring in the data from 4-5 different tabs in an excel file before performing any scrubbing. The header names are same in all the tabs. How can I accomplish this instead of bringing in input tool for each tab?
I agree with @AmalinaH . If it's the same schema then the dynamic input tool should work and you can just filter out the tabs you don't need. You can also try creating a dynamic input macro tool which you can use for both same schema and different schema tabs.
It did not work!
Try changing the action to "Change Entire Path". Also, may I know the error message you're getting.
'Tab I'm interested in' has a different schema than the first file in the set
Alright. Then that means you need a dynamic input tool macro.
can you please help me in setting that up?
Yes, we can help you get it setup, but have you tried the CReW Macro: Wildcard XLSX Input? I am a big fan of the tool for this purpose.
9 times out of 10 inputting excel sheets works well for me with this tool. If it doesn't work, then it's time to build a custom macro as @Jay-RDC suggests.
Let us know if you try this out!
Thanks,
Deb
I don;t have access to this feature in the version of alteryx we have at my employers!
CReW macros are free to install.
Download here:
http://www.chaosreignswithin.com/p/macros.html
If you want to go the macro route, please share your workflow with some anonymized files. We can help you with the configuration of the macro(s).