Automate

 View Only

  • 1.  If data column is blank, make the value the same as in SAP S4?

    Posted 03-04-2024 23:25

    Is there a way to make the data stay the same if the data column field is blank on the Excel?

    For example, making no change to 'Minimum Purchase Order Quantity' value on SAP S4, if the value in Column 'K' is blank.



    ------------------------------
    Nart Paksamut
    R.TWINING & COMPANY LTD
    Andover
    ------------------------------


  • 2.  RE: If data column is blank, make the value the same as in SAP S4?

    Posted 03-05-2024 01:57

    Good morning, I think you 're referring to the 'skip indicator' : to be defined in the run tab, by default it's a backslash, but one can chose another character. Works perfectly in transaction scripts but I had some issues with it when using direct.

    hth, Jan



    ------------------------------
    jan ketele
    release expert
    Xeikon Manufacturing NV
    ------------------------------

    Original Message


  • 3.  RE: If data column is blank, make the value the same as in SAP S4?

    Posted 03-05-2024 02:04

    Hi Jan,

    Does this mean I have to put "\K" in the value mapping?



    ------------------------------
    Nart Paksamut
    R.TWINING & COMPANY LTD
    Andover
    ------------------------------

    Original Message


  • 4.  RE: If data column is blank, make the value the same as in SAP S4?

    Posted 03-05-2024 07:42

    Hi Nart,

    no, just the backslash "\" would do, if you prefer to use another character you can define that character in the Studio RUN-tab as shown in my screenshot.



    ------------------------------
    jan ketele
    release expert
    Xeikon Manufacturing NV
    ------------------------------

    Original Message


  • 5.  RE: If data column is blank, make the value the same as in SAP S4?

    Posted 03-05-2024 22:12
    Edited by Nart Paksamut 03-05-2024 22:13

    The Winshuttle script is to update a row in Excel sheet which has several data columns, some columns are BLANK because it hasn't generated a value.

    The Winshuttle script will run that row and load all columns, if some column are BLANK, it will load BLANK. The goal is to skip that BLANK data column if it has no data and load all other column accordingly. Will this be possible?



    ------------------------------
    Nart Paksamut
    R.TWINING & COMPANY LTD
    Andover
    ------------------------------

    Original Message


  • 6.  RE: If data column is blank, make the value the same as in SAP S4?

    Posted 03-05-2024 10:01

    Hello Nart,

    it is also possible to use an IF statement and only update if the cell is populated.

    If I leave the cell blank it will pass over updating the volume.

    Thanks,
    Derek



    ------------------------------
    Derek Sayres
    Business Analyst
    Entegris, Inc.
    Chaska MN
    ------------------------------

    Original Message


  • 7.  RE: If data column is blank, make the value the same as in SAP S4?

    Posted 03-05-2024 11:31
    Edited by Josh Bawden 03-05-2024 11:31

    Depending on how if you need to populate the field with a blank sometimes and a value sometimes. We use the word "BLANK" in the field and then use an IF THEN. If there value equals BLANK then populated it with a space, otherwise take the value in column K. 

    ------------------------------
    Josh Bawden
    Information Management Engineer
    J.R. Simplot Company
    ID
    ------------------------------

    Original Message