Automate

 View Only

  • 1.  Multiple Sheet Loop Command, Command on Line Item Sheet Help

    Posted 03-09-2020 20:41
    What do I need on either the main master sheet, or the line item sheet to make this work?  Identify unique on both master and then line item sheets, then search and delete if what is in column B (Line Item Sheet) in existing (if exists)?


    ------------------------------
    Eric Sandberg | Sr Financial Systems Analyst
    Walt Disney Company - Studio Entertainment | 818-544-9898
    ------------------------------


  • 2.  RE: Multiple Sheet Loop Command, Command on Line Item Sheet Help

    Employee
    Posted 03-12-2020 10:11
    Hi Eric

    Let's forget the syntax for a minute.  You have Positions with Roles.  You want to delete a Role in a Position.  If you were looking at this in SAP, you'd want to find and open the right position and then find the right role, then do the deletion action.  This is much like you'd do it in Winshuttle.

    The LOOP will match the header and detail rows on separate sheets - for you based on position number.   The header data will have the position, so that is taken care of to find the right position.  However, since you have the ACTIONS sheet with both, you could run this just off of the Actions sheet without a multi-sheet loop - instead using a standard loop.  Your call.

    Then you want to find the right Role to delete.. So you'll want an Indexed IF on Role (not the delete flag you have now) to position to the correct role if it is equal to the value in column B.  Then you can do the delete action inside of the Indexed IF.

    Note for anyone reading this - he's using GUI scripting in a custom tcode that doesn't have a way to position to a specific row (role in this case), so that's why we need the Indexed If.

    HTH,
    Sigrid

    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------

    Original Message


  • 3.  RE: Multiple Sheet Loop Command, Command on Line Item Sheet Help

    Posted 03-12-2020 13:14
      |   view attached
    Hello Sigrid,

    Thank you for the help on this!!!!  I'm playing around with the Index Field, but it's not right.  See screenshot, as I can't write in a ​"IF" command.

    The reason I want this in different sheets is to avoid this on one sheet:
    Position - role
    role
    role
    role

    I guess I could just go across?  What do you think?
    Same sheet:
    G - N - O - P - ...
    Position - role - role - role - ….


    ------------------------------
    Eric Sandberg | Sr Financial Systems Analyst
    Walt Disney Company - Studio Entertainment | 818-544-9898
    ------------------------------

    Original Message


  • 4.  RE: Multiple Sheet Loop Command, Command on Line Item Sheet Help

    Employee
    Posted 03-12-2020 13:29
    Hi Eric

    We've been through this before a few times.  :) 

    You have to include ROLE in your recording, not that you're going to upload it, but you need it to position to the right row.

    - If it's editable, overtype it on any row in the table you need to search thru.  It will show up as a field you can upload.
    - If it's not editable, use the enable read only fields pop-up and click in the role on any row then disable the pop-up.  It will show up as a download field.

    Use it in the IndexedIF and point to the role field.  Then disable the row that either uploads or downloads the role.

    FYI
    Sigrid

    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------

    Original Message