Solved! Go to Solution.
By running your workflow I get the data below to each other. means TUCF completed in row 50 for e.g then the next file start from row 51.
I need to get the data as Column A is constant and then in Column B,C,D,E,F the numbers in the files of other excel sheets
Yes, it wasn't clear to me that you wanted the reports joined together - I assumed you wanted to read from multiple files - I understand that better now.
The only way I can think of right now that this can be done is if you build a workflow that reads each file dynamically (like we've done) and in the next step you look to build an iterative macro to join each output together. You will use the output from what we've already built as the input for the iterative macro.
I'm out of time for the evening (past midnight!), but maybe try to give that a go yourself. I'll see how you got on in the morning.
Hi,
I think I've got the solution now - another small (important!) missing piece from the problem description was that you only need the values from the 3rd column (C) - that means an iterative macro is not necessary and you can do a crosstab.
The solution will then look as below. The trick is to tell Alteryx what the row numbers are in each report so that it consistently groups each line correctly. Note that in one of your files (TUHU) there is an inconsistency, so the columns are slightly offset in that case. That will happen in each case if any one of your 200 files are not 100% consistent. It should be easy to fix once the data is together though.
I'm attaching it for now - once you have downloaded please let me know so I can delete it at my end.
If this does work - please mark this as a solution? Took me a while! 😉
Same error - No Sheet specified. I try to select the sheet in the data source folder and also tried in the separate folder.
Sheet is there, nut why this error came up?
I'm not sure why you are trying to modify the template - it already is set to recognise the files you're importing.
You should only change the 1st tool, the directory tool.
Even, I just change the first directory, no change in the dynamic input tool, the same error?
Is this creating the problem?
I'm not sure actually.
What you can do is to delete the dynamic input tool and try to recreate it. You will do something similar to what you were trying to do - select an example file from your source directory, choose the sheet you're interested in, choose that you want to output the File Name only and that the first row contains data.
Hopefully that should be it.
This making me crazy, done the same thing, same error of specify a sheet. However, I can see the sheet is already selected :s