Automate

Hi,

I'm trying to create a script that will create VKP0 conditions for ~6000 materials in ~500 plants (~3 million records total, so past the row limit of 1 Excel sheet)

I'm looking at the looping types and it doesn't look like I'm able to achieve this?

The Single Sheet loop would require me to duplicate the material information with the plant information as a header line.

The Multi Sheet loop also needs me to duplicate the material information, but this time providing a unique key to link it to the plant information
I tried with a non unique key and that didn't work either.

Have I read how looping works incorrectly?

Many Thanks,
Ken

------------------------------
Ken Lam | Data Co-ordinator
Boots UK Ltd | 0115 949 5648
------------------------------

Hi Ken,
I think you read the working of loopings correctly, besides there are different examples on this forum that can illustrate.
But I agree that leaves you with a very difficult uploadfile.
I need to do a similar upload every now and then: updating customer prices. Exactly the same issue: it leaves me with a large file, extensive loops.
So I changed the upload to an uploadfile without  loops. I don't know if it's more or less timeconsuming, but at least it gives an upload that can easily be split into different uploadfiles.
Maybe such an upload can help you too ?

hope that helps ... Jan



------------------------------
jan ketele | Sr engineer release mgt
Xeikon Manufacturing NV | +3234431875
------------------------------

Original Message:
Sent: 01-30-2022 07:34
From: Ken Lam
Subject: VK11 - Many to Many looping

Hi,

I'm trying to create a script that will create VKP0 conditions for ~6000 materials in ~500 plants (~3 million records total, so past the row limit of 1 Excel sheet)

I'm looking at the looping types and it doesn't look like I'm able to achieve this?

The Single Sheet loop would require me to duplicate the material information with the plant information as a header line.

The Multi Sheet loop also needs me to duplicate the material information, but this time providing a unique key to link it to the plant information
I tried with a non unique key and that didn't work either.

Have I read how looping works incorrectly?

Many Thanks,
Ken

------------------------------
Ken Lam | Data Co-ordinator
Boots UK Ltd | 0115 949 5648
------------------------------

Thanks Jan,

I'd built that at first, and it was only when I realised the number of entries needed when I started looking to the loops.
That's something I'm holding back on, as the only way to create the inpute file would require an external solution (VBA, PowerQuery or like such)

I'm hoping I can find a pure Winshuttle before I ask my users to grab another bit of kit.

Thanks, Ken

------------------------------
Ken Lam | Data Co-ordinator
Boots UK Ltd | 0115 949 5648
------------------------------

Original Message:
Sent: 01-31-2022 04:50
From: jan ketele
Subject: VK11 - Many to Many looping

Hi Ken,
I think you read the working of loopings correctly, besides there are different examples on this forum that can illustrate.
But I agree that leaves you with a very difficult uploadfile.
I need to do a similar upload every now and then: updating customer prices. Exactly the same issue: it leaves me with a large file, extensive loops.
So I changed the upload to an uploadfile without  loops. I don't know if it's more or less timeconsuming, but at least it gives an upload that can easily be split into different uploadfiles.
Maybe such an upload can help you too ?

hope that helps ... Jan



------------------------------
jan ketele | Sr engineer release mgt
Xeikon Manufacturing NV | +3234431875

Original Message:
Sent: 01-30-2022 07:34
From: Ken Lam
Subject: VK11 - Many to Many looping

Hi,

I'm trying to create a script that will create VKP0 conditions for ~6000 materials in ~500 plants (~3 million records total, so past the row limit of 1 Excel sheet)

I'm looking at the looping types and it doesn't look like I'm able to achieve this?

The Single Sheet loop would require me to duplicate the material information with the plant information as a header line.

The Multi Sheet loop also needs me to duplicate the material information, but this time providing a unique key to link it to the plant information
I tried with a non unique key and that didn't work either.

Have I read how looping works incorrectly?

Many Thanks,
Ken

------------------------------
Ken Lam | Data Co-ordinator
Boots UK Ltd | 0115 949 5648
------------------------------