topic Re: Dynamic table creation in Talend Studio

Dynamic table creation

psujini — Tue, 03 Apr 2018 12:13:48 GMT

Hi ,

please help me in creating the table dynamically like..

i have a data with columns country code, cuountry name ,customer name ,mobile number.i needd to create a table based on country name all records wth same country name will load in one table like ...tat many countrys that many tables need to create dynamically based on country name .the table name shloud be the country name

example

input

sno country name country code customername

1 USA 01 abc

1 UK 02 fgc

1 USA 01 ahgj

1 Uk 02 jksjbc

1 INDIA 03 abc

;1; INDIA 03 abc

O/p:table anem:USA

sno country name country code customername

1 USA 01 abc

1 USA 01 ahgj

;;;;

sno country name country code customername

1 Uk 02 fgc ==>table name:UK

1 Uk 02 jksjbc

like that .....Any suggestions?

;;;

Re: Dynamic table creation

manodwhb — Tue, 03 Apr 2018 13:41:07 GMT

@psujini,read the unique country name from file and populate to tFlowToIterate and from flow you iterate as shown in below job design.since you need to use (String)globalMap.get("row7.country_name")) global variable to filter and table name and the actionon the table would be Create Table.

Re: Dynamic table creation

manodwhb — Thu, 05 Apr 2018 05:45:02 GMT

@psujini,did it help ?

Re: Dynamic table creation

psujini — Fri, 06 Apr 2018 13:05:56 GMT

Thank you!

its working fine..