Each excel row activity

OK get it thanks, may i know what pattern mean?
image
do i can use it for all cases as im using real data?

image
and can i ask also for this part


can u assist me on this?


can assist me on this?

i have try to run using my real data but the unwanted row still there. may i know if i can use exactly like yr workbook or i need to change according the data?

Hi,

Can you share your workflow and data, if possible?

Regards,

actually the data is quite confidential. or do u have any idea on how i can give u what u need?

Hi,

i have attached the data. in the excel, other the in column A is not a whole number i want to delete. in this data, it must be 1,2,3,4 but in future there will be 5 so how do i need to delete that any row that is not 1,2,3,4 in column LOB.
during manual, i will sort all column by column named lob then will delete any row that show other than 1,2,3,4

EXAMPLEDATA.xlsx (4.6 MB)

Hi,

Can you try the following sample? This outputs result to new sheet named “result”.

NewBlankTask20221219-1.zip (2.3 MB)

Please note that your column name “LOB” is contains extra whitespace at the end of the string.
And it’s necessary to evaluate value as numeric in Filter Datatable activity.

Regards,

Here is the workbook and excel
Main.xaml (23.8 KB)
EXAMPLEDATA.xlsx (4.6 MB)
EXAMPLEDATA.txt (4.7 MB)

Can u assist me on this?

HI,

Does the above sample NewBlankTask20221219-1.zip work for you?

Regards,

oh sorry i missed yr sample, i open it now

May i know where i need to edit the expression editor

image

HI,

Does the above sample work for you? If it works, no need to modify.

Regards,


Is im using the same read range with u ? it a bit different from your workbook, can i use this?


it show this

do i need to edit LOB as u said ?

i have amend for LOB as in the editor but it still come out the column is not set

hi can assist me on this?