Hello there,
I was wondering, is it possible to import an excel file with multiple sheets? I have attached a file for reference
Where I would only be using <To be Imported> tab's values to work out a formula as per <formula> tab?
Thanks!
Here's a good link to look at.
Hi @cluk019
Yes, it is possible. Take a look at the attached workflow
1) Configure the input tool to export the sheet names and the file name
2)Use the formula tool to generate the full path for each sheet name
3)Use the dynamic input tool OR the batch input macro to import each sheet to Alteryx
If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)
Thanks.
Hello! Thanks for replying!
I understand your workflow completely, but can I just upload a file (which has 3 tabs) but I only want to import 1 tab, which is the <To be imported> tab?
Can you please guide me how?
Thanks!
This was Great!