where a.Customer NOT IN(select distinct Customer from CustomerSalesData where InvoiceDate < '2020-07-01')
Statement below is a column I use for an sql query..
ROW_NUMBER() over(partition by a.Customer order by MIN(a.InvoiceDate)) as OrderNum
I am getting an error while trying to convert this statement. I am not sure how to convert it into something that Domo will understand.
Can this be done in beast mode or MagicETL?
Thanks for any help.