I'm learning AAE for like a week and I have problem with for loop in excel file. I have prepared table with Vendor Id, Material, and order Quantity:
Vendor Material Quantity
25000 1545454 100
64003 7854786 1024
25000 5896471 250
25000 3336661 900
64003 7854786 2048
25000 3336691 900
And I wanted to validate the table if there is any redundancy in the material and vendor column. I have created 6 variable 2 for each column and named them: POv, POm, POq and Vpo, Mpo, Qpo. And of course 2 itterators Itteraor2 and Itterator3 that I am incremanting in 2 loops
Problem is that my loop is infinite, while I wanted only to iterate 6 times (number of rows) and additionally it is messaging me that row 2 AND 3 have the same vendor ID and material ID what is not true. Could somebody tell me what is wrong and how to fix it?