Find the blank column and and working from blank column

[ashishmani (ashish mani tripathi)]

Visit type sample.xlsx (81.0 KB)

→ I want to pick the PID, but the issue is that I have to skip all the entry where the L column which is the status column fills,

→ I want to start our loop from where the status column is blank until end

[ppr (Peter Preuss)]

@ashishmani
as a first step give a try on following:

• read range - reads in the excel into a datatable

• filter datatable - filter expresession to status column is empty - output: dtFiltered

• for each row on dtFiltered

• picking up the PID - row(“PID”).toString

[ashishmani (ashish mani tripathi)]

can u plzz make a xmal from me, because I am new here

[ppr (Peter Preuss)]

@ashishmani
have a look here:

filter settings:

Also do not miss out to refer to the helping courses from Academy

[ashishmani (ashish mani tripathi)]

thanks

[ashishmani (ashish mani tripathi)]

hi i have another issue., this is right solution, but when bot entered the status in status column, its enterning from the top,