4 Replies Latest reply: Sep 11, 2018 8:40 AM by Глеб Аитов RSS

    Where not exists problem

    Глеб Аитов

      Hi!

      I need to do the following - please, help.

       

      Screenshot_1.jpg

       

      FirstOrderTable:

      Load

      OrderN as OrderNx,

      First_Purchase

       

      Resident FlagTableTmp

      Where First_Purchase=1

      ;

      Drop Table FlagTableTmp;

       

       

      Concatenate (FirstOrderTable)

      Load Distinct

      OrderN as OrderNx,

      '0' as First_Purchase

      Resident Main_table

      Where not Exists(OrderNx,OrderN)

      ;

      Rename Field OrderNx to OrderN;

       

       

      The script error says: The name 'OrderN' already exists


      Thank you!