Read Multiple Invoice Files

[raj_kiran]

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.

[caltang]

You'll need to provide some data in the sheets, and can you give more examples of variations?

In addition, which parts do you need exactly? This is not an easy task for sure - it'll take a lot of effort to get right.

[Buzz]

Hi raj_kiran,

please check this post and its solution. It might help you. 

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/File-has-a-different-schema-th...

Best regards

Sebastian

[raj_kiran]

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.

[raj_kiran]

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

[caltang]

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.