Hi,
I am trying to use split activity to limit each of the data group to 2 rows.
I am getting the following error
XTK-170036 Unable to parse expression ' AND [temp:extract-grp:@internalRank]<=2'.
XTK-170037 'AND' is a binary operator. At least one operand is missing.
Executing extraction 'Subset' (step 'Split')
I have three fields in my table - Delivery, URL, Counts
I would like to get the top 2 rows in the group of each Delivery, URL
For example:
Delivery URL count
D1 abc 5
D1 abc1 3
D1 ABC3 2
D2 pqr 7
D2 pqr1 6
D3 pqr2 5
Expected output:
Delivery URL count
D1 abc 5
D1 abc1 3
D2 pqr 7
D2 pqr1 6
I am using the following documentation to perform the limit.
Can you please suggest what could have caused this issue.
Thanks a lot
Naveen
Solved! Go to Solution.