Skip to Content
Former Member
Sep 16, 2014 at 07:39 PM

Issue in Hierarchy Text Node


Hello Experts,

I am trying to load Cost Center from BW.

In the BW object there are many junk record which I want to skip.

For Eg: I want to have specific Co Areas in and want to skip all records if they are blank or have other then specified.

In Transformation file

Co_Area=*IF(CO_Area=*STR() then *STR(NA);CO_Area)

In Conversion file i have specified

NA *skip

* *skip

The issue is that it skips the hierarchial node also since the Controlling area is blank.

Is there some way how i can skip the blank records of Controlling area but does bring the hierarchial node?