Filter the rows based on 2 columns using Filter Datatable

[Chaitan]

Hello ,

I am trying to the filter the rows based 2 columns which are start date and Expected arrival date.
I need to filter rows with the condition “Start date is after the Expected arrival date”.

This is how wriiten, but i was getting empty rows

[Manuel_Dominguez (Mdominguez)]

Hi try to use this

validDT = ExcelDT.Select(" ([Rule]=‘1977’ AND ([SHIP DATE] > [EXPECTED ARRIVAL DATE] )").CopyToDataTable

Let me know if this works

[Chaitan]

I was getting below error
Assign: The expression is missing the closing parenthesis.

[Chaitan]

[Manuel_Dominguez (Mdominguez)]

Do you already fix it?

[Chaitan]

Yeah I fixed that, but now am getting different order

[Manuel_Dominguez (Mdominguez)]

Chage “Rule” for “RULE” in the Assing, if the error continues, could you pass me the File?

[Chaitan]

Dupliacte File.xlsx (58.9 KB)

I need to create 2 files based on below conditions

Exempt File

If “Penalty Due” is 0, change “Status” to Exempt

Valid File

If “Rule” is 1947 and “Ship Date” is after “Expected Arrival Date”, change “Status” to Valid and “Comments” to Shipped Late

[Manuel_Dominguez (Mdominguez)]

@Chaitan

Exempt

The Ship date should be after o could be after or equal

[Manuel_Dominguez (Mdominguez)]

Chech this workflow
Chage Values dependig condition.xaml (16.5 KB)

Let me kwow if you have any question.
These are the Results:
Exempt_Table.xlsx (10.2 KB)
Valid_Table.xlsx (24.7 KB)

[Chaitan]

Can you tell me the dependencies

[Manuel_Dominguez (Mdominguez)]

Just update those dependencies

[Manuel_Dominguez (Mdominguez)]

Also check Excel depedencies

[Chaitan]

I got it ! Thanks for the solution.

[Manuel_Dominguez (Mdominguez)]

If that works
can you Assing it as “solution”