topic Re: How to get column name from dynamic data type which is defined in tMysqlInput? in Talend Studio

How to get column name from dynamic data type which is defined in tMysqlInput?

Anonymous — Sat, 16 Nov 2024 04:47:27 GMT

Dear all,

I want to get all the column name which is defined on tMysqlInput component and the flow is contained in the picture below.

- Inside the tMysqlInput, I defined the Query which related to context variables, so it will change sometimes I run it. So I defined the Schema which is "dynamic" type.

- My target is getting all the column name with it's data in Mysql.

Who can help me for this case please!!!

Thank you guys!

Re: How to get column name from dynamic data type which is defined in tMysqlInput?

Anonymous — Wed, 04 Sep 2019 14:02:44 GMT

Try this in your java row

Dynamic dyn = row1.dynamic_column_name;
Set<String> columns = dyn.getAllColumnNames();

If you want to loop through them all you can do something like

for(int i = 0; i < dyn.getColumnCount(); i++){
	DynamicMetadata meta = dyn.getColumnMetadata(i);
        String col_name = meta.getName();
}

Re: How to get column name from dynamic data type which is defined in tMysqlInput?

Anonymous — Thu, 05 Sep 2019 03:35:10 GMT

Thank you @evansdar for your help. It worked perfectly!

Re: How to get column name from dynamic data type which is defined in tMysqlInput?

Anonymous — Thu, 05 Sep 2019 03:54:14 GMT

Also, my currently purpose is getting data from mysql (about rows size which I defined before) and then put it into dataset. The final flow is:

Could you please help me how can I transform it into dataset from tMysqlInput (which used my custom query)?

Thank you and hope you have a happy day!