topic Re: [resolved] Creating Dynamic table in TOS in Talend Studio

[resolved] Creating Dynamic table in TOS

kvinoth19991 — Tue, 05 Jul 2016 11:29:05 GMT

Hi Guys ,

I need to create dynamic table with the use of data from file

For Example :
file1.csv
Sno;ColumnName
1;Name
2;Gender
3;Age
4;Address

By reading the file1.csv - I should dynamically create table with columns - Name , Gender , Age & Address

Thanks in advance

Regards,
Vinoth Kumar K.

Re: [resolved] Creating Dynamic table in TOS

kvinoth19991 — Wed, 06 Jul 2016 06:39:01 GMT

Guys ,
Any idea on this ?
Please sugguest me someway

Regards,
Vinoth Kumar K.

Re: [resolved] Creating Dynamic table in TOS

Anonymous — Wed, 06 Jul 2016 07:59:59 GMT

What about the other column properties such as data type, length?

Re: [resolved] Creating Dynamic table in TOS

kvinoth19991 — Fri, 08 Jul 2016 06:47:27 GMT

Thanks for the response shong

All the column properties will have same data type and length

Help me to do it.
Regards,
Vinoth Kumar K.

Re: [resolved] Creating Dynamic table in TOS

kvinoth19991 — Wed, 13 Jul 2016 07:55:19 GMT

Guys ,

Please give me some idea

Thanks & Regards,
Vinoth Kumar K.

Re: [resolved] Creating Dynamic table in TOS

Anonymous — Fri, 15 Jul 2016 08:41:56 GMT

Hi
I think you can write a create table statement based on each row on a tJavaFlex, and then execute the statement on a tPostgresqlRow.

tFileinputDelimited--main(row1)--tJavaFlex
|
onsubjobok
|
tPostgresqlRow

on tJavaFlex:

In the begin part:
String query="CREATE TABLE tableName (";

in the main part:
//assuming the datatype of all column is varchar, and the length is 10
query=query+row1.columnName+ " varchar(10),";

in the end part:
//remove the last common"," and append ")";
query=query.substring(0,query.lastIndexOf(","))+")";
globalMap.put("query",query);

On tPostgresqlRow:

(String)globalMap.get("query")

Regards
Shong

Re: [resolved] Creating Dynamic table in TOS

kvinoth19991 — Wed, 20 Jul 2016 08:01:30 GMT

Thank you so much shong