Importing DATA

[yoli1]

Hello guys, i imported data into a the staging table and i created a transform map to transform the data everything did transform ass expected. i did go back again to the transform map already created because i wanted to change the filed maps and add a source script after doing that when i go and click transform again on the transforming map it says : No import set available. Create and load an import set first. Should i do the import again i already did it in the first and created a staging table. and when i go to load data again and choose already existing table and choose the table i already created i need to put the excel file again. can someone explain to me why we need to put the excel file again?

[nancystodd]

When you load data into an import table, the rows have a status of 'Pending' until a transform map is run. Then they change their status to show if the row was inserted, updated or skipped. At that point, the data is no longer usable to the transform map so, when you try to rerun the transform, it gives the error you received. The solution is to return to the data source and click again to load all data. If the source data has not changed, you do not need to re-upload the Excel spreadsheet since it is already attached to the data source. You just have to click on "Load All Records" to reload the data and your transform should work.