Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a csv file (see the foto below)
the second row must become a column (Gen, Feb, Mar ...)
and I want to concatenate all the columns into one column:
0.0
0.2
0.4
.
.
.
6.4
11.2
12.4
6.2
.
.
.
6.0
etc
this is the csv file :
in talend i create metadata > FileDelimited :
this is how i would like the output:
Day | Mouth | Year | Daily_Data | Station
1 | Gen | 2014 | 0.0 | SGemini
2 | Gen | 2014 | 0.2 | Sgemini
3 | Gen | 2014 | 1.4 | Sgemini
... and so on, for all day ....
31 | Gen | 2014 | x | Sgemini
1 | Feb | 2014 | 11.2 | SGemini
2 | Feb | 2014 | 12.4 | SGemini
...
...
1 | Dic | 2014 | x | SGemini
...every day of December
31 | Dic | 2014 | x | SGemini
can you help me please?
Hi
Can you provide an example for testing?
Regards
Shong