[resolved] Dynamic column mapping in TIS

[djugal]

hi,
can we pick up a csv data irrespective of the mapping,
e.g. i have 3 cols coming frm csv: name age sex
i want csv to mysql
i can do it the first tym but what if the column order is not constant. it can come in any sequence other tym
like age sex name etc.
can it be done by dynamic schema ? if so how ?

[Anonymous]

Hi djugal,
Dynamic schema works for your case even though the sequence of columns varies in the source file.
BTW, the link you provided cannot be opened. Would you mind pasted the details content into the forum. I will appreciate it very much. Thanks a lot.
Best regards
Sabrina

[djugal]

hi sabrina,
can u elaborate how would dynamic schema work in my case ?
regards,
djugal

[djugal]

'http://bekwam.blogspot.in/2011/06/dynamic-schemas-in-talend-open-studio.html'

[Anonymous]

Hi djugal,
Let's still use your example:
1: In a first hour, inputting " name;age;sex" into your target DB, and then the data will be inserted into a table.
2: Here comes the second hour, inputting "age;name;sex" into your target DB, and then the data will be inserted into the existed table created by the first hour.
Source file for a first hour:
name;age;sex
sabrina;26;f
shong;30;m
john;28;m
Source file for the second hour:
age;name;sex
45;york;m
23;dan;m
18;mary;f
The actual result is : see pic
When the table has been created, the structure in DB is fixed. But dynamic schema will arrange your input data into the corresponding structure ignoring the order.
Best regards
Sabrina

[djugal]

Hi,
i have the same job structure as your example except oracle output,
filedelim -----> oracloutput
i am getting this error while executing in the logrow component:
ORA-00947: not enough values

[Anonymous]

Hi,

ORA-00947: not enough values

How many columns in your existed table? I think this issue is produced by missing insert column. For example, there are 3 columns age,sex,name in your table, but your input is just age,sex.
You can search it on Mr.Goolge to get more info about this issue description.
Best regards
Sabrina

[djugal]

Worked like a charm...............
Thanks Sabrina

[Anonymous]

Hi,

Thanks for your feedback.
Best regards
Sabrina

[Anonymous]

Hey,
This post is little old, but i wanted to know something related to it.
What if the column names are also different? say name in one file and names in other. can we map it dynamically(after reading a file or something)?

[Anonymous]

Hi ksultania,
Here is a response in your another forum https://community.talend.com/t5/Design-and-Development/resolved-Dynamic-Column-Mapping/td-p/109075, could you please take a look at it?
Best regards
Sabrina