Automate

I'm trying to create a script that update the NStg (Next Stage) field with the same DynR (Modification Rule).

Example per screenshot, updating only the row with DynR = TW5.

I recorded a GUI script with Index condition but it doesn't seem to work. The script will only work with the first row that it finds for TW5.

Attached Script and Data file.

------------------------------
Best Regards,
Nart
------------------------------

Attachment(s)

QDL2.xlsx   5 KB 1 version

Attached script.

Attachment(s)

QDL2 - Update NTsg.Txr   78 KB 1 version

Hi Nart

This isn't an area of expertise for me, nor have I found a way to replicate what you have.

Here are some ideas:

• look for a position
• look for a filter
• look for a BAPI
• Indexed IFs only work on unique values - so maybe use the operation number instead?

I would look to use a Query to extract based on DynR value you want to filter to, and include the fields you want to update plus the operation number

Hope that gives you a few ideas,

Sigrid

Hi Sigrid,

I did find a way. There's an option 'Find All' in the condition setting, this works.

That's great, Nart! You're tackling some tough use cases.

Best Regards,

Sigrid