Check value with increment in excel file - problem string/integer

[Sam_Taf (Tafat Samir)]

Hello,

In a excel file, I want to check the column K and if it’s < 0, i have to write a message in column L.The problem is that i have a message that string is unable with integer.

How i can do this process (Vlookup? other?).

FinalReport.xlsx (11.0 KB)

Thank you for your help?

Bests regards.

[Pratik_Wavhal]

Hi @Sam_Taf

The problem is that i have a message that string is unable with integer.

can you elaborate above sentence more

Happy Automation

Best Regards
Er Pratik Wavhal

[Sam_Taf (Tafat Samir)]

Thank you very luch for your answer @Pratik_Wavhal.

I can’t reproduce the error but i don’t have the waiting result. The column K is obtained after a Vlookup and i thnik that the column has a string format and it can’t be compared with 0.

I’m sorry i began with Iupath just 2 days ago and it’s little bit difficult.

Thank you again for your help.

[Pratik_Wavhal]

Hi @Sam_Taf

So you use it as below
CInt(column_K_value) < 0

This will convert the string variable to Int just while comparing and after comparing what ever result/message you can store it in Column L

Mark as a solution and like it if this helps you

Happy Automation

Best Regards
Er Pratik Wavhal

[Sam_Taf (Tafat Samir)]

Hi @Pratik_Wavhal

I’m sorry but I don’t find Cntl when a select a if condition.

Do I have to select a « if condition » and write your formule in the condition?

Thks

[Pratik_Wavhal]

Hi @Sam_Taf

I said CInt

I’m sorry but I don’t find Cntl when a select a if condition.

you are doing “Cntl”

And yes within If condition i told you to do that

please have a look when reading the post.

Happy Automation

Best Regards
Er Pratik Wavhal