https://community.qlik.com/t5/Talend-Studio/load-csv-to-database/m-p/2253013#M36487 <P>I have a tab delimited csv file that i need to load into a database as rows. The input file has unknown number of fields and unknown field names -- "ID" column is known.</P> <P>Please see below. I tried tNormalize but didn't work. The issue is that data in first row is part of "key" data. How do i go about this? Thanks!</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 308px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lufb.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/156681i9A740A423A644EF2/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lufb.png" alt="0683p000009Lufb.png" /></span></SPAN>&nbsp;</P> Mon, 05 Jun 2017 22:06:24 GMT Anonymous 2017-06-05T22:06:24Z https://community.qlik.com/t5/Talend-Studio/load-csv-to-database/m-p/2253013#M36487 <P>I have a tab delimited csv file that i need to load into a database as rows. The input file has unknown number of fields and unknown field names -- "ID" column is known.</P> <P>Please see below. I tried tNormalize but didn't work. The issue is that data in first row is part of "key" data. How do i go about this? Thanks!</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 308px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lufb.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/156681i9A740A423A644EF2/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lufb.png" alt="0683p000009Lufb.png" /></span></SPAN>&nbsp;</P> Mon, 05 Jun 2017 22:06:24 GMT https://community.qlik.com/t5/Talend-Studio/load-csv-to-database/m-p/2253013#M36487 Anonymous 2017-06-05T22:06:24Z https://community.qlik.com/t5/Talend-Studio/load-csv-to-database/m-p/2253014#M36488 <P>This problem interested me, so I solved it for you. I've done it using Talend 6.2.1 (hopefully you can use that). It's a bit late here to explain it in detail, but take a look at the job and see if you can figure it out. It works given the example data in your post....<BR /><A href="https://drive.google.com/open?id=0B4ssYWXVaQJUcHNtREdvUklFbVE" target="_self" rel="nofollow noopener noreferrer">https://drive.google.com/open?id=0B4ssYWXVaQJUcHNtREdvUklFbVE</A></P><P>&nbsp;</P> Tue, 06 Jun 2017 01:19:02 GMT https://community.qlik.com/t5/Talend-Studio/load-csv-to-database/m-p/2253014#M36488 Anonymous 2017-06-06T01:19:02Z