Column header in two rows

[Grayfox]

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.

[HansS]

Hi @Grayfox

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

[Grayfox]

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.

[HansS]

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?

[Grayfox]

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

[HansS]

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

[Grayfox]

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)]