Column header in two rows

Hi everyone,

I need you help about configuration of a Excel reader Node.

I know i Can choose the number of row to specify the column header, but in my data there is twos rows witch contains my colomn header.

Date mai-18 mai-18 mai-18 juin-18 juin-18 juin-18
Product Type Reference Color Qantity Price Sale Qantity Price Sale
A Clothes 1269.51 Black 50 69 3450 10 69 690
B Cars AM4150 Red 3 10650 31950 9 10650 95850
C Drink PUI-419 Blue 60 26 1560 7 26 182
D Computers MPO14MM Green 3 590 1770 3 590 1770

In this exemple I would like to group the row number 1 with row number 2 to make this my column header.

The result will be like this.

Col0 Product Col1 Type Col2 Reference Date Color mai18 Qantity mai18 Price mai18 Sale juin18 Qantity juin18 Price juin18 Sale
A Clothes 1269.51 Black 50 69 3450 10 69 690
B Cars AM4150 Red 3 10650 31950 9 10650 95850
C Drink PUI-419 Blue 60 26 1560 7 26 182
D Computers MPO14MM Green 3 590 1770 3 590 1770

Then I need to remove col0, Col1, Col2 by blank.

Do you think it’s possible .

Thank you a lot.

Hi @Grayfox

See this post merging-multiple-rows-into-one-single-header-row . Is this you are looking for?
gr. Hans

3 Likes

Thank you so much @HansS , It’is exacly what I want.

There is maybe an additional task to complete my workflow. I want to merge this multiple rows in one single header for multiple files.

So, if it’s possible to integrate this task in a loop to treat all files and get a single table ?
The column header for each files can be different.

If it’s not clear ? I can try to give you an example.

1 Like

Hi @Grayfox . I think that will be possible, but my question is; what’s the final table look like, do you want to add rows or add columns or both?

I want to add both, columns and rows, with missing values for the not communs columns (exactly what the concatenate node do).

Hi @Grayfox the workflow in this post Merging multiples excel files with different columns loops over all Excel files in a directory en combines them together. Integrate it with the workflow I suggested in this post, and I think you are done.
Gr.Hans

1 Like

Thank you for the help. But i don’t think it’s working, because I have different column’s names on my files.

The message error : Execute failed: Input table’s structure differs from reference (first iteration) table: Column 0 [Time, Country (String)] vs. [Time, City (String)]

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.