Skip to Content
0
Former Member
Apr 07, 2011 at 02:28 PM

Handling blank in transformation file

25 Views

I am trying to use if statement in a transformation file. I have got data set where members in one of column (Column 3-INTCO in this example) are empty so I want to map these missing ones to a specific dimension member. For other (non-missing) ones I want to map as usual way.

The code I got it

INTCO = *if(COL(3)= then *NEWCOL(I_EXTERNAL); COL(3))

I have also tried some other options like

INTCO = *if(COL(3)= NULL then *NEWCOL(I_EXTERNAL); COL(3))

INTCO = *if(COL(3)= u201Cu201D then *NEWCOL(I_EXTERNAL); COL(3))

But none of this is working. I found a SAP help on internet but this is not helping either. Main issue I am having is how system check =empty/blank condition in the above statement?

The SAP help is available at

http://help.sap.com/saphelp_bpc75/helpdata/en/a2/e722bc58404335ada8592cdc8feaca/content.htm

Has anyone experienced similar issue and able to solve this?