topic Convert Dynamic to String in Talend Studio

Convert Dynamic to String

rmcclure — Sat, 16 Nov 2024 00:21:33 GMT

I have a requirement to run a series of 49 SQL statements and collect the results.

These SQL statements are stored in a Snowflake table. I need to read the table get each of the 49 SQL statements, execute each of them and collect the results of each into another table.

One issue is that the 49 statements return 49 different sets of results (ex: number of fields and field type). I found I can run and display the results with output column of type Dynamic. The target table has a type of String so I need to convert the dynamic field to one big string instead of extracting the individual fields.

I tired using a tExtractDynamicFields with a string as the output but it comes out NULL.

Re: Convert Dynamic to String

Anonymous — Mon, 29 Mar 2021 07:01:41 GMT

You need to get the schema properties and

concatenate all fields into one string on a tJavaRow,/tJavaFlex, please look at this blog to learn how to get the schema properties at runtime.

Regards

Shong

Re: Convert Dynamic to String

gjeremy1617088143 — Tue, 30 Mar 2021 08:32:32 GMT

hi you could do something like this in a tJavaRow with input_row Dynamic and output_row String :

Dynamic columns = input_row.newColumn;

String str ="";

for (int i = 0; i < columns.getColumnCount(); i++) {

DynamicMetadata columnMetadata = columns.getColumnMetadata(i);

str += columns.getColumnValue(i);

}

output_row.newColumn = str;

Re: Convert Dynamic to String

archienesss — Thu, 12 May 2022 12:54:25 GMT

Hello Shong,

Thanks for your reply! But I am hoping this blog post you shared can be made available again. I really think this is exactly what I am looking for. Thanks again!