Read Multiple Invoice Files

Question

Hello,

I’m stuck at an Alteryx process which I need assistance on.

Requirement here is to read around 50 to 100 files from a folder (similar to attached dummy invoice samples) which have different schema and not at the right ordering and create a single output file with all the details.

Please could you suggest a solution on the same.

Sample 1.xlsx

Sample 2.xlsx

caltang · Answer

Sorry @raj_kiran - the differences between files are just too major for any workflow to consistently produce a reliable output. Unless you trim down your scope to only files of a certain data frame, then it would be a good use case.

raj_kiran · Answer

I have checked this link earlier but this test case is more complex.

raj_kiran · Answer

Thank you for the response. The highlighted cells are the ones which i need data from.
Also, I wont be able to provide the data however any dummy value can be added in the highlighted cells for testing.