cancel
Showing results for 
Search instead for 
Did you mean: 

Transformation issue in SAC Data Model

Mr-Singh
Explorer
0 Kudos

I have built a new model with data source as csv. Therw were 7 transformations and I arrived at a final column as output which I need. Now when I m trying to load new data. Model is expecting all the columns to be mapped from source. How to reload the data and proceed further. Please advice.

View Entire Topic
N1kh1l
Active Contributor
0 Kudos

@Mr-Singh 

Not sure what was the workflow used. But once you created the the transformation and the job, you should just edit the job and replace data source and select the new file, your transformation should remain intact.

Nikhil

Mr-Singh
Explorer
0 Kudos
Would like to exlain further, I have lets says 4 columns in source csv have derived one column using transformation lets say substring,. Now I added some more records to excel and trying to load the data. It asking for the transformed column to be mapped with a new source column. Which should not happen.I tried in many ways but same issue. Need further comments, help on this if possible. Im using csv as source