Multiply conditions case

Hi All,
My case:
I have a data in Excel file, three columns:
1 Email Subject
2 PO number
3 one of three different status: Can be confirmed, Already confirmed in SAP, no signature on the confirmation
I my have few rows with the same Email Subject
Now what I need:
Have to chose those Email Subject for which all statuses are ‘Can be confirmed’ if t least on status is differ I no dot want it.
Please look at the attached Excel
Excel example.xlsx (9.5 KB)

I will be at the end moving the messages to subfolder but firstly have to verify above. (I know how to execute this)

1 Like

Hi @niteckam,

So you want the mail subjects in the excel file which has “Can be confirmed” as the corresponding status, right? Please refer the below .xaml and let me know if that works :slight_smile:

Main.xaml (13.6 KB)

HI @PAVITHRAN

No this Is not what I want. It will be to easy.
You may have the same Subject Email and several different statuses in Colum C
I want to take only those Email Subject for which all statuses are “Can be confirmed”
If at least one status is differ then I do not want to take that Subject Email

Additionally Im thinking more about the activities around DataTable
I do not want to operate on open excel application

1 Like

Hi @niteckam.

I have drafted up a quick example of how it could work using LinQ and Datatable.Select

Hope it helps :slight_smile:
Confirm if all grouped dt rows match multiple criteria.xaml (10.7 KB)

You can add your subjects to a list to move those specific messages that match the criteria

Thanks,

Tim

@TimK
Thank you, that’s help a lot

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.