Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

transform N columns into N lines

Can anybody help me how to go about this.I am a complete beginner to Talend even to any ETL tool..Need to implement batch loading using talend.
Can anybody help me in the below
My input will be a complex join between different tables(oracle databse)
My output is a delimited file(which needs to be ftpd)
My problem is the structure of the output file is as below
id 9429979F6
value 96.5
sectype XYZ
secsubtype XYZ
secsubtyp2 XYZ
Coup 3.32
descript "ABC"
rating1 A
rating1id X97886
id 9229979F6
value 26.5
sectype X2YZ
secsubtype X2Z
secsubtyp2 X2YZ
Coup 3.32
descript "ABC"
rating2 A
rating2id Y9789-78
and so on
The column names are at the left handside(dynamically generated from database eg rating1 exists in database so is present in the first data)
Can anybody help me how to go about this
Labels (2)
21 Replies
_AnonymousUser
Specialist III
Specialist III
Author

Hi cOutta/amaumont
I have a problem with mapping two tables using tMap.Can you please help me out with this..This is related to the below topic..
2069
Abrar
_AnonymousUser
Specialist III
Specialist III
Author

sGLgIY <a href="">kztbbwfesfsk</a>, bggqujtwyftr, fderfnuoqlwj,