4 Replies Latest reply: Oct 6, 2017 6:32 AM by Antonio Mancini RSS

    Different columns comparision

    Priya R

      hi Community,

       

      Can you please share any thought you have for the below requirement.

       

      I have 2 tables,

      1.

      Table1:

      Dim1,Dimx,Dixy,Join_key;

       

      2.

      Dim2,Column1,Colmn2,if(Dim1=Dim2,1,0) as Complex_Key,Join_key;

       

      in the 2nd tab I have two create Complex_Key based on table1,

      can you please share your thoughts.

      it is not possible to have Exist function.

       

      -Priya