Skip to main content

Hi all,

 

I need to copy 3 policy number one by one from an excel and perform a certain job after that.

 

  1. Copy first policy number (1st row), paste in system and run step 11-15
  2. After step 15 done, go back to excel and copy 2nd policy number (2nd row), paste in system and run step 11-15
  3. After step 15 done, go back to excel and copy 3rd policy number (3rd row - last row), paste in system and run step 11-15
  4. End

 

However, the job i created will straight away end after copy and paste the 1st row.

But if i remove the Step 11 from my AC, it works fine - keep looping for 3 times to paste the policy number.

 

Can you all help me to see what's wrong with my job?

 

Below is the output from excel - only take the first column value.

25553iF050A4135DA3D5E2.jpg

25554i4A3836DC493C9FD7.jpg

Each time after copy the policy number, it will continue step 11.

25555iE4A73EC90FC1A793.jpg

 

After step 11 done, it should go back to loop...not ended like below..

25556iAE06D9186470AB7D.jpg

 

 

 

 

you can do that by removing 1st row of the excel every time after the pasting in system, also can create a copy of excel to save all data as well.



 



like every time you paste data in system the 1st row of data will be removed and after posting you can add go to step 11 and again get data from the 1st position which is the 2nd in the previous first loop.



 



Please find attached image for details.



Thanks


Reply