How can I update one cell in column from other cell in SAC Model using something like WHERE clause?

[RajeshTikhade]

Experts,
Your quick help is highly appreciated.
I have model getting data from multiple sources. I would like to combine data from other rows in the model.
Example: Update "Age" based on "EmpID". Then remove duplicate rows based on "EmpID".
Model:
EmpID ,EmpName, Age
00123, John Doe, #
00576, Jane Smith, #
00147, Sally Curtis, #
00123, #, 54
00576, #, 32

Expectated output:
EmpID ,EmpName, Age
00123, John Doe, 54
00576, Jane Smith, 32
00147, Sally Curtis, #

I know, this is very basic request. But with programming it can be achieved through WHERE clause. But with limited function we have at SAC, it is getting cumbersome.
Note: I do not have DataSphere or do not want to use any data wrangling tool, before getting data from source

[William_Yu1]

Hi RajeshTikhade, 

    I'm not certain about your use case. Looks to me, information like EmpName or age are unique to an EmpID, they can be better modeled as property of dimension EmpID. So instead of combine that at model level, you can import them as master data property . 

Best regards, William 

[RajeshTikhade]

William , Thank you for taking time. My request is getting data from multiple sources, which coming from SAP system directly. I need to consolidate "Age" and "EmpName" on "EmpID". This is just example; it could be any column needing consolidation based on WHERE condition. So, question is do we have option to use WHERE condition and treat Model data as Table data? I did try and explore option of directly importing data as property of master data field but could not get that either. So if you can elaborate more master data and properties upload in model will be greatly appreciated. Thank You , Rajesh

[William_Yu1]

There is no 'WHERE' condition for sure, but you may model the join key (the dimension, i.e. EmpID) as property of another dimension. Then use advance formula to combine the data properly. BTW, for classic model, join different data source during data import is supported, while this feature for new model is not available yet. Again, not all columns need to be dimension in SAC, this should be considered wisely.