Transpose different tables of a file

[caneerajdwivedi]

Hi All,

I get a file in a specific format. Where First table "Customer master data" contains master data and another table "Directors/Signatory Details" contains their director names (refer to sample 1 and sample 2). There might be another table but I want to ignore that. I want to convert these files in a format as specified under output.xlsx. Please help me out.

[Qiu]

@caneerajdwivedi 
It is not that pretty.

[caneerajdwivedi]

Thank you so much. It works pretty well. Just one thing.. i've thousands of these files. Can we make input directory-based, like alteryx will read and convert all files in a specific directory?

[Qiu]

@caneerajdwivedi 
I was thinking there might more files, but you said you are going to ignore, so I guess I misunderstood.

In such case, a batch macro will be in place.

Allow me some more time and get back to you with that macro.

Note that the data schema of input file should stay same in order for this flow to work.

[caneerajdwivedi]

I meant to explain that i want to use two tables (Customer master & Directors details) of all files files and ignore other tables like "Charges" etc.

[Qiu · Accepted solution]

@caneerajdwivedi 

This is the one I prepared.

[caneerajdwivedi]

Thanks for your excellent work. 😄 It really saved me a lot of time.

[Qiu]

@caneerajdwivedi 
Glad to help and thank you for the accept mark. 😁