[resolved] dynamic column

[lemufty]

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

[Anonymous]

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

[lemufty]

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.

[lemufty]

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

[Anonymous]

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

[lemufty]

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



 

[lemufty]

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

[lemufty · Accepted solution]

i resolved my problem.
this is my workflow

[lemufty]

how can i add number which identified each row