Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How do I calculate the duplicate flag value in load script?
Ex:
Column 1 | Column 2 |
Product1 | No |
Product2 | No |
Product3 | Yes |
Product3 | Yes |
I need the script to calculate the column 2.
Hi
Try like this
Load If(Previous([Column 1] = [Column 1], 'Yes', 'No') As "Column 2" from tablename order by [Column 1] asc;
Hope that helps
Hi
Try like this
Load If(Previous([Column 1] = [Column 1], 'Yes', 'No') As "Column 2" from tablename order by [Column 1] asc;
Hope that helps
Thanks, Its worked.