Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I would like to add a column in the data load editor.
I have 2 products, product 1 and product b. for these i have 3 columns with dates. Date C, Date D and date E.
newcolumn = if product A, Date D - Date C, if product B, date E - date C
can somebody help me with the syntax?
@gumpy May be you try something like below:
if(Match(Product,'A'), DateD-DateC, if(Match(Product,'B'),DateE-DateC)) as New_Column.
I think this should resolve your issue.