Make conditional dimension

[agni_gold]

Hi All ,

I have a table in which only one column and this table is individual loaded in my data model , not link to any table ,

Field Name is ABC

And from my data model i have picked one dimension XYZ , i want to write in dimension

If (XYZ<>ABC,XYZ)

This is not working please explain why

[sunny_talwar]

Can you share a sample if possible?

[Anonymous]

Use RecNo() in both the table to assign a unique value and then try to do what you are looking at.

Example would be helpful for us to guide you properly in one go.

[#4]

Try doing mapping load like this:

ABC_MAP:

Mapping Load

     ABC,

     1

From Datasource;

Main Table:

Load

     if(XYZ_Temp = 1,XYZ) as XYZ

;

Load     

    XYZ

     applymap('ABC_MAP',XYZ,null()) as XYZ_Temp

From Datasource2;