0 Replies Latest reply: Sep 26, 2016 10:11 AM by Andreas Gumaelius RSS

    Combine flags from different tables as a union

    Andreas Gumaelius

      Hi,

      I've built a set expression in a straight table that combines the results of two flags in the script.

       

      If(Customer='A',Y,N) as CusFlag

       

      From CustomerTable;

       

      And

       

      If(count(CustomerSales>3,Y,N) as CountFlag

       

      From FactTable;

      I know the syntax is simplified but hope you get the idea.

       

      Now I'd like two combine those two flags in the script so that I don't have to build a union expression in set analysis. I'd like to have

      a flag that says:

      FlagTotal Yes/No in the application where Yes combines the results of CusFlag and CountFlag.