how to delete rows with #Na from the start of the bottom rows till particular row value

[prthmesh111]

below is a input 

Values

#Na

1234

5678

#NA

1234

5678

#NA

#NA

#NA

i want to remove only the last 3 #NA value it can be in n numbers 

below what the output should be

#Na

1234

5678

#NA

1234

5678

[christine_assaad]

Hi @prthmesh111 

Below is a way of how to achieve the desired output. Hope this helps.

 

[prthmesh111]

It can be in n number not only 3 it can be more than 3 

[ChiN]

Hi prthmesh111,

Can you give us more details? 

My understanding is that you wanted to take out #NA values from certain rows. 

You can use sample tool to choose only the rows that you want. I provided the workflow below.

Is this the solution you were looking for?

[christine_assaad · Accepted solution]

@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!

[prthmesh111]

i want to remove #NA value from the dataset which starts from the bottom of the row, not from the top and middle of the rows.  it can contain n number of #NA at the bottom. using sample i can select the top rows but it can be more than 6 i don't know the count.

[grazitti_sapna]

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.

[prthmesh111]

the approach you provided is quite lengthy but it works fine. Thanks alot....