Transformation File-If statement reading from two BW infoobjects

[a_ahmad]

Hi everyone,

Requirement: If Account 1111100000 then read data from BW field 0INVESTOR and if 0INVESTOR is empty then map to TP-INVNONE.

For all other accounts read data from BW field 0PARTNER and if 0PARTNER is empty then map to TP-NONE.

First tried like

PARTNER = *IF(0ACC=*STR(1111100000) then 0INVESTOR; 0PARTNER = *STR() then *STR(TP-NONE); 0PARTNER) - This works but I need to catch where 0INVESTOR is empty and for this I tried like:

PARTNER = *IF(0ACC=*STR(1111100000) then 0INVESTOR; 0INVESTOR = *STR() then *STR(TP-INVNONE); 0PARTNER = *STR() then *STR(TP-NONE); 0PARTNER) -> This is not catching where 0INVESTOR is empty.

could you please give any idea how to fulfill this requirement?

thanks

Ahmad

[former_member190501 · Accepted solution]

Hi,

Just try

PARTNER = *IF(0ACC+0INVESTOR=*STR(1111100000) then *STR(TP-INVNONE); 0ACC=*STR(1111100000) then 0INVESTOR; 0PARTNER = *STR() then *STR(TP-NONE))

Hope it helps..

regards,

Raju

[a_ahmad · Accepted solution]

thanks Raju,

this worked

[Former Member]

Hi Ahmad,

Try use the combination of transformation and conversion file.

you can do a mapping in the conversion file for the empty 0investor.

map the emtpy member to TP-INVNONE

ps, it is not recommended to use - as a dimension member.

Andy