Skip to Content
0
Former Member
Feb 24, 2009 at 06:14 PM

Handle null values in trsnformation files

60 Views

Hi all,

I need to replace null values coming from BI with some constant because of BPC restrictions(you can't load transactional data if the key is not in master data).

if FIELD = ´´ then EMPTY else FIELD

Could you please give me the IF sentence syntax for doing that?. And where should I use it, in FORMULA column or in EXTERNAL column?

Thanks a lot!!!