Create a dynamic column and extract its content

shameer1 — Sat, 16 Nov 2024 05:27:12 GMT

I tried to follow the below link to understand how to use dynamic datatype and extract its content.

https://help.talend.com/reader/KxVIhxtXBBFymmkkWJ~O4Q/WX1guuvSnxZg5nBBQ26LBQ

My source data (attached in the doc) which has mixed datatype (integer,varchar and date).

I have designed the job as

tFileInputDelimiter (column ->Dynamic) --> tJavaRow.

Used the below code in tJavaRow.

Dynamic columns = row3.dynamic;
 
for (int i = 0; i < columns.getColumnCount(); i++) {  
    DynamicMetadata columnMetadata = columns.getColumnMetadata(i);  
    System.out.println(columnMetadata.getName() + ": " + 
columns.getColumnValue(i) + "; " + columnMetadata.getType());
}

But I could find the the datatype derived from columnMetadata.getType() of all the extracted column is showing as id_String.
And If i use columnMetadata.getDBType(), then i am getting all the extracted column datatype as varchar . Output data attached in the sample.

Can anybody let me know how to get the exact datatype (like integer ,date) for the required column, instead of varchar for all the columns.

Re: Create a dynamic column and extract its content

Anonymous — Thu, 27 Jun 2019 15:02:42 GMT

Hi @shameer ,

When you read the data dynamically from a file, Talend will consider everything as string only.

To see the actual datatype, you can provide the schema in Input File with actual datatype and then use tWriteDynamicFields, and after that you can use your method to see the actual datatype.

Thanks and Regards,

Subhadip

topic Re: Create a dynamic column and extract its content in Talend Studio

Create a dynamic column and extract its content

Re: Create a dynamic column and extract its content