Concatenate & value replacement

[Tommmy]

Hi experts

simple question but I was  not able to solve it: I need to replace the value of "Account" to 'XX' in any case. This will be done in the second step within the Concatenate. Any ideas how to write the code correct?

Trans2:
LOAD *

resident Trans1 where KONTO = '4011';

Concatenate (Trans2)
LOAD *

,if(len(trim(Account))=0,'XX', 'XX')

resident Trans1;

[MayilVahanan · Accepted solution]

Hi

If you want the Account - 'XX' in any case, try like below

Load urfields,  'XX' as Account resident Trans1;