Five Stars

Dynamic table creation

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?

 

;;;

2 ACCEPTED SOLUTIONS

Accepted Solutions
Twelve Stars

Re: Dynamic table creation

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

Untitled.png

Manohar B
Twelve Stars

Re: Dynamic table creation

@psujini,did it help ?

Manohar B
3 REPLIES
Twelve Stars

Re: Dynamic table creation

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

Untitled.png

Manohar B
Twelve Stars

Re: Dynamic table creation

@psujini,did it help ?

Manohar B
Five Stars

Re: Dynamic table creation

Thank you! 

its working fine..