Handling blank in transformation file

[Former Member]

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?

[Former Member · Accepted solution]

Hi,

You can try using something like below:

INTCO = *if(COL(3) + *str(abcd)= *str(abcd) then *str(I_EXTERNAL); COL(3))

Hope this helps.

[Former Member]

Thanks you. solved.

Edited by: rohitktm on Apr 7, 2011 5:57 PM