I have nearly 65 excel(xlsm) files all have the exact same structure. Only the data is different. I have a summary sheet in all of the files and would like to input summary sheets into Alteryx designer from all the files.
Please can someone show me how to do it.
Solved! Go to Solution.
I've worked through the reading of the xlsm's and used a Directory Tool to find them. Then used a dynamic input to read them all. I also added the filename so that I know where each record comes from.
Cheers,
Mark