Mapping

[dseelam]

Hello All

I have 2 fields ID & categories in data model from oracle, Now I have an flat file with diff ID and categories missing from oracle

now I want to include flat file in to data model and map categories from both sources in to Make or Buy

how is it possible?

Message was edited by: Dinesh Reddy Seelam

[krishnacbe · Accepted solution]

Hi Dinesh,

Please find the attached solution.

After concatenate/Join/Add statement, you have used apply map with * statement, that caused the Synthetic Keys.

Dropping the first table will solve the issue. But verify the data.

[vishsaggi]

Try this to concatenate !

Leave the Mapping table and Finished table as is and do below and refresh and see?

In the Edit Script Flatfile Tab:->

Concatenate

LOAD id,

     category

FROM

C:\Users\VNAGARAJ\Desktop\Book1.xlsx

(ooxml, embedded labels, table is [all items]);

Concatenate

load *,

applymap('CatMap',category,'NA') as MakeBuyFlag

Resident finished;