topic Re: [resolved] how to convert dynamique type to another type in Talend Studio

[resolved] how to convert dynamique type to another type

lemufty — Wed, 13 Jul 2016 16:03:32 GMT

hi,
this is below my csv
col_id;col_number;col_text
1;4;6Vhssg
2;3;5RmazH
3;seven;PaaFCa
4;1;DkUBYCQKJHJUIHUKJHKUYHIUH
9;text;ur0tXy
10;12;GFOBB
my workflow contain tfileInputdelimited(which have 1 column dyn and type is dynamic) =>tmap =>tfileOutputdelimited
in tmap, i lied dyn(input) to several columns(ID,NUMBER,TEXT)
so when i define type of these column, i hav error message i cannot convert dynamic type to integer,string.
how can i do. do you have another idea.
thank you

Re: [resolved] how to convert dynamique type to another type

Anonymous — Thu, 14 Jul 2016 09:59:07 GMT

Hi,
Could you please take a look at this topic: thread to see if it is what you are looking for?
Best regards
Sabrina

Re: [resolved] how to convert dynamique type to another type

lemufty — Sun, 17 Jul 2016 09:20:14 GMT

hi,
i look at this discussion and thank you.but it don't resolve my problem because i want to control data structure.
for example check that one column is format integer and data compliance.
my csv contain data. where can i define schema(structure) of data.tks
regards