Hi Experts,
I am creating a transformation to map BPC master data with BW cube.
In transformation file, one of the condition for WBS coloumn is:
WBS=*IF(GL(1:5)=*STR(10104) then Assignment;WBS)
In above condition my additional requirement is that if both WBS and Assignment columns are blank (Having no values) then it needs to hard code as "NO_WBS".
Please suggest a way to incorporate this requirement in transformation file.
Thanks,
Karan