Append and join - CSV

Hamder83

Hi, 

I have 4 files i would like to have joined dynamically.
The issue is: 
In file: 

InvoiceSummary.csv - I have:
Kundenummer:,,90183621,,,PostNord,,,,,,,,,,
Navn:,,United Broker A/S - Direct Inj. DK,,,SHARED SERVICE FINANCE,,,,,,,,,,
Fakturadato:,,31.01.2020,,,HEDEGAARDSVEJ 88,,,,,,,,,,
Fakturanummer:,,150519519,,,2300 København S,,,,,,,,,,

The 4 lines needs to be added as coulums for each file.

The 3 files, does not have the same header structure, nor the same starting positioning.

So I was thinking if I need to create 1 flow, adding the 4 lines to each file as coloumns.

And trimming until the header.. and then joining?


I hope someone could show me how this could be done ... 

Kind regards

InvoiceSummary.csv

InvoiceSpecification.csv

InvoiceSpecificationGroupage.csv

RWvanLeeuwen

@Hamder83 

I am confident in stating that there is no out of the box and instant solution for your use case. However, with Alteryx at your side and with my proposed solution I think you'll reach the next level fairly quickly by simplifying the problem and transforming it into bit-sized chunks for which you can use specific tools.

You might want to look into youtube video's from Alteryx on how you can automate the dataprocessing of multiple files using batch macros. Or you can look at multi-row formula to dynamically mark where your headers are. Will you experiment with the tool a bit more and provide us with some more specific questions along the way?

If my initial solution helped you to solve your initial case, please consider marking it as an accepted solution for others to find.

Best,

Roland

Infotopics - Benelux partner of the year

Empowering business through analytics. See, Understand, Act!