Hi Pradip and all,
Unfortunately, it does not seem like what I want.
This is the scenario:
In my data model I have a field called SalesPerson (SP). Let's called this SP_qvd
I have a SalesPerson table in the data warehouse - this holds static data. Let's call this SP_ETL.
When there is a change in sales person name, instead of updating SP_ETL I update an Excel sheet that feeds into my data model (SP_qvd). Let's call the Excel sheet SP_xls.
SP_xls has two columns: OriginalName and NewName. Column OriginalName is also present in SP_ETL.
John Old, a sales man has changed his name to John New. The first step is to update SP_xls below:
OriginalName NewName John Old John New
Please how do I write the logic below:
IF SP_xls.OriginalName EXIST IN SP_ETL.OrignalName
CHANGE/UPDATE SP_qvd WITH SP_xls.NewMan
I have looked at Pradip qvw and it suits me.
However, this is a question. In the event SP_xls having three columns (including a unique key column)
Original_Name_key Original_Name New_Name 1 John New John 2 Paul New Paul 3 Jake New Jake 4 Tim New Tim 5 Peter New Peter
Is this the way to write the code?
([Original_ ApplyMap('Map_Original_name', "Original_Name_key"),ApplyMap('Map_New_Name', ""Original_Name_key")),