topic Re: [resolved] dynamic column in Talend Studio

[resolved] dynamic column

lemufty — Tue, 12 Jul 2016 14:59:40 GMT

hi, morning.
this my problem. my file csv contain 3 columns(id,number,text). i work with talend enterprise. in my fileinputdelimited, i create 1 column dyn et type is dynamic.i lied my fileInputdelimited to tlog. but when i execute it, tlog display 1 column with contain id,number,text. so i want that my tlog display 3 columns. how to do it?
thank you for your help

thank you for your help

Re: [resolved] dynamic column

Anonymous — Wed, 13 Jul 2016 09:24:46 GMT

Hi,
Could you please try to use tfileoutputdelimited component instead to see if it works well?
Best regards
Sabrina

Re: [resolved] dynamic column

lemufty — Wed, 13 Jul 2016 09:58:48 GMT

oki, thank you for your help. so i want to do control on this 3 columns(col_id;col_number,col_text)
For each column, if the expected format, check the expected length. if the length is bigger than the
expected one then truncate it to the expected length else transcode the value. Format are integer for col_id,
,integer for col_number, String for col_text.
if data of column is not compliant, i rejet this data
example:col_id;col_number;col_text
;4;6Vhssg
2;3;5RmazH
3;seven; sds => reject this line because seven is not good format (integer).

have you an idea to do with talend.

Re: [resolved] dynamic column

lemufty — Sun, 17 Jul 2016 09:09:49 GMT

how i can control data structure in talend. thank you for your help

Re: [resolved] dynamic column

Anonymous — Mon, 18 Jul 2016 08:54:45 GMT

Hi,
From your description, it seems that you are looking for TalendHelpCenter:tSchemaComplianceCheck component which is used to check types, nullability, length of rows against reference values.
We see that you are using dynamic schema feature. I s your input source unknown column structure (unknown name and number of columns)?
Best regards
Sabrina

Re: [resolved] dynamic column

lemufty — Mon, 18 Jul 2016 14:58:05 GMT

hello xdshi,yes i use dynamic column.i use tsetdynamic to define my schema.in tjavaflex i arrive to localize each column.but i cannot approuve or reject data which not compliant to my structure. example test id, if(columneName=="id" && columnType="Integer")
{row2.dyn=row1.dyn
} else row3.error=row1.dyn
i do this because i wa,t to reject in other tlog(error) all data which not compliant to my structure. thank you for your help

Re: [resolved] dynamic column

lemufty — Tue, 19 Jul 2016 20:37:30 GMT

i decide to try another method.
this is my workflow: tfileInputDelimited =>tjavaflex=>tmap=tmap;
i arrive to retrieve to tjavaflex all columns from dynamic column of tfileinputdelimited.
so i want to load all columns to tmap?
how can i do it.
thank you for your help

Re: [resolved] dynamic column

lemufty — Thu, 21 Jul 2016 14:15:37 GMT

i resolved my problem.
this is my workflow

Re: [resolved] dynamic column

lemufty — Mon, 25 Jul 2016 16:21:27 GMT

how can i add number which identified each row