Dynamic table creation

[psujini]

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?

;;;

[manodwhb · Accepted solution]

@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.

[manodwhb]

@psujini,did it help ?

[psujini]

Thank you! 

its working fine..