load csv to database

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)

Accepted Solutions
Sixteen 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

 


All Replies
Sixteen 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

 

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.