Transposition of 2 rows and 10 columns contained in a txt file

[Anonymous]

Dear all,
As i am new to talend i am having problem transposing 2 rows and 10 columns
The rows and columns are contained in a txt file...but some how the job is created
for only a single such file now i want to transpose for min10 such files
The exact scenario is i have a main folder which has 10 subfolders
each of which contain such file.so need to use the same job for all these
files .How to go about it?

[Anonymous]

Hi,
Due to the variable, tMap deal with "row" in stead of "Column". (see my screenshots)
Could you please elaborate your case with an example with input and expected output values? Maybe there is a proper component for your requirement.
Best regards
Sabrina

[tomasbasso]

Ok, the problem is posted by many users but unresolved. Is TRANSPOSE excel files (columns begins rows)
No Tturnrow, UnPivot or other components may help me.
Unfortunately who give me this excel file don't understand what are fields and records.
The schema is :
ID ; 1 ; 2 ; 3 ; 4
NAME ; William ; Joe ; Lara ; Bob
SURNAME ; Brown ; White ; Red ; Green
and so on for 348 fields (first column fieldsname, every columns a record)
I need to put this records in a SQL server table, but for processing i need to TRANSPOSE
ID ; NAME ; SURNAME
1 ; William ; Brown
2 ; Joe ; White
3 ; Lara ; Red
4 ; Bob ; Green
Now i use
texcelinput -- tfiltercolumn(singlecolumn) -- tdenormalize -- tfileoutputdelimited(in append)
But :
1) excel files have no schema due to records (maybe 1 column(record) maybe 20 columns)
2) due to columns i have to repeat the flow 1 or 20 times due to filter single columns
If there is a component that can rotate this file i finish my problems.....
Sincerely