This content has been marked as final.
Show 4 replies
-
-
2. Re: Filter out records
Jeff Stanley Aug 10, 2018 9:24 AM (in response to meenu choudhary)that is a great start, but I only want to filter out the "111" records that share a name with a "888", the "888" should not be rejected. I also did not notice that the account numbers were the same on the 888 and 111 records, that is just a coincidence in making the random data - I really need to key off the "name" field to filter out.
-
3. Re: Filter out records
meenu choudhary Aug 10, 2018 9:42 AM (in response to Jeff Stanley)1 of 1 people found this helpfulHI Jeff,
If you want to have logic for only 111 and 888 then below calc you can try:
1. Left = left(str([Account number]),3)
2. chk = {FIXED [Name]: if COUNTD([left])<>1 then "No" else "yes" end}
3. Flag= if [chk]="No" and [left]="111" then "reject" END
-
4. Re: Filter out records
Jeff Stanley Aug 10, 2018 10:07 AM (in response to meenu choudhary)this is great, thanks