Extract specific column values from excel and apply if condition on the latest version 2023.4.1

[Sunil_Kumar1 (Sunil Kumar)]

I want the if condition that should match with any of of the excel column value, so that i can proceed with some steps. Please help me on this

[arjunshenoy]

Hi @Sunil_Kumar1

Can you please specify the condition that you want to check? Also, in the If condition, you can directly use CurrentRow(0) = yourCondition format to check the desired condition.

Best Regards.

[Lekshmi_R]

Could you specify what condition you wanted to check? You can give that condition in the if activity directlly as CurrentRow(0)= Condition and proceed with the rest of the logic in the if block.

[Sunil_Kumar1 (Sunil Kumar)]

opDt(0).ToString.Equals(ID) giving error where ID is my input and opDt out put of Get Row Item
Current(0) also giving error

[Sunil_Kumar1 (Sunil Kumar)]

opDt(0).ToString.Equals(ID) giving error where ID is my input and opDt out put of Get Row Item

[Anil_G (Anil Gorthi)]

@Sunil_Kumar1

Is the project in c# or vb.net?

If in c# use currentRow["ColName"].ToString().Equals(ID)

Cheers

[Lekshmi_R]

Get row item will give you a single value. But you are trying to access opDT(0) which is not correct. Can you try opDT.ToString.Equals(ID)

[Sunil_Kumar1 (Sunil Kumar)]

Thank you so much it worked