Four Stars

load csv to database

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.

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!

 

image.png 

Tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions
Twelve Stars

Re: load csv to database

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....
https://drive.google.com/open?id=0B4ssYWXVaQJUcHNtREdvUklFbVE

 

Rilhia Solutions
1 REPLY
Twelve Stars

Re: load csv to database

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....
https://drive.google.com/open?id=0B4ssYWXVaQJUcHNtREdvUklFbVE

 

Rilhia Solutions