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
June 21, 2019, 8:34pm
2
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
HansS
June 26, 2019, 7:19pm
4
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).
HansS
June 27, 2019, 4:51am
6
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)]
system
Closed
January 2, 2020, 3:31am
8
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.