OK get it thanks, may i know what pattern mean?
do i can use it for all cases as im using real data?
and can i ask also for this part
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
HI,
Does the above sample work for you? If it works, no need to modify.
Regards,
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?