I need to filter multiple excel columns data

[vinjam_likitha]

Hi Team

Below is the input file.
Test.xlsx (10.6 KB)

Filtering condition:
Remove if Transaction Type-“INT” and “REV_REC”
Currency other than-“USD”
Total Amount-0

Thanks in advance
Likitha

[rlgandu]

@vinjam_likitha

Use Filter Datatable activity

[vrdabberu (Varunraj)]

@vinjam_likitha

CurrentRow("Transaction type").toString.Contains("INV") Or CurrentRow("Transaction type").toString.Contains("REV_REC").tostring

Hope it helps!!

[Nguyen_Van_Luong1 (Nguyễn Văn Lương (Albert Nguyễn))]

Hi @vinjam_likitha ,
You can use filter data

Regards,
LNV

[vinjam_likitha]

I have tried like this but it is not working

Thanks
Likitha

[mkankatala (Mahesh Kankatala)]

Hi @vinjam_likitha

=> Use read range workbook activity to read the excel to datatable. Output - dtExcel.
=> Use for each row in datatable activity to iterate the rows in the datatable.
=> Inside for each Insert the If condition and write the below condition.

- Condition - (Currentrow("Transaction type").ToString.Contains("INV")) and (CurrentRow("Transaction type").ToString.Contains("REV_REC")) and (Not (CurrentRow("Currency").ToString.equals("USD"))) and (Cint(CurrentRow("Total Amount")).equals(0))

=> In then block give the remove data row activity.
=> Use write Range workbook activity to write the datatable to excel.

Check the below image for better understanding:

Hope it helps!!

[lrtetala (Lakshman Reddy)]

Hi @vinjam_likitha

O/P:

Regards,

[vinjam_likitha]

Hi @lrtetala

I need Currency USD other than USD i need to remove

Thanks
Likiitha

[lrtetala (Lakshman Reddy)]

@vinjam_likitha

[Akshay_B]

Hello @vinjam_likitha
I have attached the Main.Xaml File, You can follow the steps as in:
Main.xaml (9.7 KB)
I hope it helps.
Regards;)

[mkankatala (Mahesh Kankatala)]

Check the below workflow for better understanding :
Expressions_Practice.xaml (13.5 KB)

Check the below reply for process and condition

I need to filter multiple excel columns data

Hi @vinjam_likitha => Use read range workbook activity to read the excel to datatable. Output - dtExcel. => Use for each row in datatable activity to iterate the rows in the datatable. => Inside for each Insert the If condition and write the below condition. - Condition - (Currentrow("Transaction type").ToString.Contains("INV")) and (CurrentRow("Transaction type").ToString.Contains("REV_REC")) and (Not (CurrentRow("Currency").ToString.equals("USD"))) and (Cint(CurrentRow("Total Amount")).equ…

Hope it helps!! @vinjam_likitha

[vinjam_likitha]

Thank you all for the solutions