3 Replies Latest reply: Apr 28, 2013 5:48 AM by Stefan Wühl RSS

    If Condition in Load Script

      Hi All,

       

      I need to create a Flag (1 or 0) by checking my _LoadKey value

       

      For example my key value is like this:

       

      if(123##) then 1

      if(##232) then 1

      if(112##234) then 0

      if(##) then 1

       

      I have one key by combaining the coln1 and coln2 like this,

       

      col1 &'##'& col2 as _LoadKey   in Fact Table

       

      and in LoadData table i have the same key

       

      col1 &'##'& col2 as _LoadKey   in Fact Table

       

      Now i'm doing inner join with Fact,

       

      Like this

       

      Fact:

      Load A,B,

      col1 &'##'& col2 as _LoadKey

       

      From Fact.qvd

       

      inner Join

       

      Load X,Y,

      col1 &'##'& col2 as _LoadKey ,

      I need to create that flage condition here ( I wrote some thing like this

       

      if

      (FindOneOf( SALES_DATE &'##'& STORE_KEY,' '),1,0) as LoadFlag ) but it's not working

       

      From LoadLog.qvd

       

      Thanks,

      Selva