data load add colum on condition

[gumpy]

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?

[sidhiq91]

@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.