[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 · Accepted solution]

Hi,
Dynamics schema can deal with your issue as your described
See the related reference https://community.talend.com/t5/Design-and-Development/How-to-process-changing-data-structure/ta-p/2...
However, dynamic schema is only available in Talend Enterprise subscription version.
Best regards
Sabrina

[djugal]

thks sabrina

[Anonymous]

Hi,
Feel free to post your issue on forum, you are welcome.
Best regards
Sabrina

[djugal]

1 more question dynamic columns can be mapped directly to the target using Pass-through mode can i have an example of this ?

[Anonymous]

Hi,
There is no more examples about dynamic schema scenario except for the example in article I have given to you.
But for your requirement, I have designed a demo job for you.
The work flow is: tFileInPutDelimited-->tMySqlOutPut and the source file is:
name;age;sex
sabrina;26;f
shong;30;m
john;28;m
See my screenshots for more details. Hope it will help you.
Best regards
Sabrina

[djugal]

k but i mean what is the cols fro the csv are not in order
like name sex age instead of name age sex
in that case is there a way in dynamic schema we can map the fields
thks & regards,
djugal

[Anonymous]

Hi,
Do you mean there are three columns name,age and sex which arranged randomly.
Dynamic schema don't care the order and it just map the source file into target file. If the source file order is name,age and sex, the target file will correspond to that. If the source file order is age, name and sex, the target file must be age, name and sex.
If I misunderstand your meaning, would you mind giving more description to me?
Best regards
Sabrina

[djugal]

ok so i guess dynamic schema is not the thing i a looking for i guess,
see my prob is
i have a input file coming every hour in the schema : name sex age
mysql table has schema: name sex age
i have to run the job every hour to append the data.
my question was suppose at a time i got the schema of the input file in irregular sequence say name age sex
how can my job handle this jumble without errors. can this be achieved via dynamic schema ?

[djugal]

i found this link of bekwam's blog correct for my scenario
http://bekwam.blogspot.in/2011/06/dynamic-schemas-in-talend-open-studio.html
thks & regards,
djugal