StudioX - compare the data from the first column and the seventh column

[teslyak9437 (Sam)]

How to compare the data from the first column and the seventh column? If they are different, then write the date from the seventh column to the variable.
How to implement this in StudioX

[Ajay_Mishra (Ajay Mahendra Mishra)]

@teslyak9437 Please share the screenshot in put excel!

Regards,
Ajay Mishra

[teslyak9437 (Sam)]

First colom
Seventh colom (in this colom is formula)

[ashokkarale]

@teslyak9437,

Here is sample code for this problem.

Input file:

Solution Overview:

Watch out for date format in your file. If you get any error related to Date formatting compare your date format in file and this section of code.

Sample Code:
ExcelActivity.zip (72.0 KB)

Output:

Thanks,
Ashok

[teslyak9437 (Sam)]

If I need to check only the data that I have inserted, I have the beginning of the record and the end of the record written into a variable ?

[ashokkarale]

@teslyak9437,

In tat case you can add a If Condition activity before date check condition like this.

Here I’m expecting you have start Index/row number in double datatype

Revised Code:
ExcelActivity.zip (72.2 KB)

Thanks,
Ashok )

[teslyak9437 (Sam)]

I have this problem

[ashokkarale]

@teslyak9437,

Check the date format in your file and in the if condition at 1.1.1.3.1. It should be same.

Thanks,
Ashok

[teslyak9437 (Sam)]