How can we create a new source table of Transform map

[pwr227]

I need to import choices of a variable so first I need to create a source table so that table I am able to select in transform map's "Source table field" so how can we create new source table any idea? please find the attached snapshot.

[Maik Skoddow]

Hi @pwr227 

before you can transform you first have to load the data via any data source. That loaded data is stored a table you could select for your transform.

Maik

[Jaspal Singh]

Hi,

It is creating the table as you normally do with only difference being you extend table it as 'Import set row'

[Anand Kumar P · Accepted solution]

Hi @pwr227 ,

From left navigation type load data module and create new one one give name and attach file

Then click  on submit and click create new transform map link

Create new transform map and give name and target table to load data

Click on automap matching fields or do field maps

After that click on transform link then data will be transferred to target table.
Mark it as helpful and solution proposed if it serves your purpose.
Thanks,
Anand