below is a input
Values
#Na
1234
5678
#NA
i want to remove only the last 3 #NA value it can be in n numbers
below what the output should be
@prthmesh111
Please take a look at the attached and let me know if it solves the challenge.
It's trying to detect the last N NA records dynamically.
I tested it on different N records and it seems to work. Perhaps there could be other ways to tackle the problem. Cheers!
Hi @prthmesh111
Below is a way of how to achieve the desired output. Hope this helps.
It can be in n number not only 3 it can be more than 3
Hi @prthmesh111 , if the last 3 values will always be #NA irrepective of the count of records let it be N numbers then you can use record id tool then sort it in desc order then skip the first 3 records using sample tool and then again use sort tool by asc on record id and this may work for you. Please refer to the screenshot and workflow.
