Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can any one can give me an advice to deal with this issue...
il have multiple files (more than 10)
each of them have a key but not exhaustive.... and its own column
i would like to merge all of them into a unique fiel with all columns.
here is an example of my source files :
.---+------. |tLogRow_1 | |=--+-----=| |key|col120| |=--+-----=| |1 |A | |2 |B | |3 |C | |5 |E | '---+------' .---+------. |tLogRow_2 | |=--+-----=| |key|col121| |=--+-----=| |1 |W | |2 |X | |3 |Y | |4 |Z | '---+------' .---+------. |tLogRow_3 | |=--+-----=| |key|col123| |=--+-----=| |1 |R | |2 |S | |3 |T | |6 |U | '---+------'
here is the traget file wanted
.---+------+------+------. | tLogRow | |=--+-----=+-----=+-----=| |key|col120|col121|col123| |=--+-----=+-----=+-----=| |1 |A |W |R | |2 |B |X |S | |3 |C |Y |T | |4 |null |Z |null | |5 |E |null |null | |6 |null |null |U | '---+------+-----+-------'
thanks in advance for your help
i have found an ugly solution....
begining with a fileList to get an exhaustiv list of key from all files,
then loading each files linked into a tMap
... i would prefer a loop or a iteration instead of loading them each "manually"