Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can someone help me with this tricky task.
My task is flag the ID's with New or Repeat. In a month if the Primary ID have multiple Secondary ID.
Example:
We have to flag as 'New' / 'Repeat'. Earlier Date - 'New'
else
If It's same date, Earlier ID is 'New'
Here are my inline text, and screenshot for better understanding.
Set Flag like this:
LOAD * INLINE [
Primary_ID, Secondary_ID, Product Name, Date
1, A101, AAA, 2/8/2018
1, A102, BBB, 2/7/2018
2, A103, AAA, 2/21/2018
3, A104, BBB, 2/4/2018
3, A105, AAA, 2/7/2018
3, A106, BBB, 2/9/2018
4, A107, AAA, 2/10/2018
4, A108, BBB, 2/10/2018
5, A109, AAA, 2/15/2018
6, A110, BBB, 2/18/2018
6, A111, AAA, 2/18/2018
6, A112, BBB, 2/18/2018
7, A113, AAA, 2/3/2018
7, A114, BBB, 2/23/2018
];
