List of Contributions

Henri Mäntysaari

Contact Details

My Content

1 to 18 of 18 total

RE: Specifying Criteria during Query

Posted By Henri Mäntysaari 08-25-2022 01:43
Found In Egroup: Automate \ view thread
I don't think it's possible to rule out the crossover results within the query. If it is, I'd like to hear about it too. I believe that previously this issue has been solved using a separate Excel formula. It concatenates the given criteria and extracted results and then compares them, probably using ...

RE: Resulting Value for Concatenation

Posted By Henri Mäntysaari 08-22-2022 01:34
Found In Egroup: Automate \ view thread
Hi, sorry, I was on a holiday so I'm replying now. The semicolons are due to my PC's Office localization. It uses ; instead of ,. Hmm, actually I didn't originally separately check the correctness of the sorting, I assumed it would work in a normal excel manner. I did check now and they seem to ...

RE: Resulting Value for Concatenation

Posted By Henri Mäntysaari 07-28-2022 03:23
Found In Egroup: Automate \ view thread
Sorry, I'm not able to share the file itself but here are relevant screenshots Workspace Criteria Mapping Transform rule After publishing to excel, running and adding filters to the top row it's possible to sort ------------------------------ -- ---------------------------- ...

RE: Resulting Value for Concatenation

Posted By Henri Mäntysaari 07-26-2022 03:26
Found In Egroup: Automate \ view thread
Hi For testing I created a query with material number, plant and follow up material and added a =concatenate( -formula using transform rule in the query. I published and ran the query and then was able to Sort in the spreadsheet using excel from the concatenated column. I'm not sure why it wouldn't ...

RE: Winshuttle does not process lines

Posted By Henri Mäntysaari 07-21-2022 02:29
Found In Egroup: Automate \ view thread
Log to WS and SAP in Excel From Excel's Winshuttle ribbon select the correct embedded script Filter blanks not to be visible on the column that gives the transaction's input From right side select Specified rows -> Filtered From the middle select Run -> Run specified range --------- ...

RE: Winshuttle does not process lines

Posted By Henri Mäntysaari 07-20-2022 09:14
Found In Egroup: Automate \ view thread
If you don't wish to alter WS general settings for the sake of getting a single script working, I guess you could also filter Blanks not to be visible from the Agreement number column and use "Specified rows -> Filtered" and "Run Specified range". ------------------------------ -- ------------- ...

RE: Winshuttle does not process lines

Posted By Henri Mäntysaari 07-19-2022 03:13
Found In Egroup: Automate \ view thread
Hi Are you sure you need a loop for this? Wouldn't ME33K work just as a normal transaction, since it'll need only the agreement number? In your spreadsheet screenshot the agreement number is found on column A and the script screenshot refers to U for upload, is this correct? ------------------------------ ...

RE: Query: Criteria as comparing two SAP fields

Posted By Henri Mäntysaari 06-30-2022 06:57
Found In Egroup: Automate \ view thread
Apparently your customer service contacted my company's Winshuttle provider about this. They in return contacted your WS customer service again, who told that creating a query like this is not possible. I wonder why my WS provider was brought into this. Maybe I didn't create the enhancement request correctly ...

RE: Query: Criteria as comparing two SAP fields

Posted By Henri Mäntysaari 06-17-2022 02:02
Found In Egroup: Automate \ view thread
I could suggest that (and something else as well). Are there instructions somewhere how to request an enhancement? ------------------------------ -- ------------------------------

RE: Query: Criteria as comparing two SAP fields

Posted By Henri Mäntysaari 06-16-2022 01:43
Found In Egroup: Automate \ view thread
Thank you for your reply. I see, what a shame. I probably don't have the time to find out how to use the SQVI. I may try to use WS Query but extract the materials in parts, maybe based on PH. Then compare the weights in Excel. Let's see. ------------------------------ -- ----------------------- ...

Query: Criteria as comparing two SAP fields

Posted By Henri Mäntysaari 06-13-2022 02:24
Found In Egroup: Automate \ view thread
Hello community, I'd need to extract from SAP a list of materials that have a larger Net weight than Gross weight value on Basic Data. Obviously this fault causes issues, and listing the materials would be first step towards solving them. I'm trying to do this with a WS Query. I cannot extract ...

RE: Only 1million lines in the Query result-file

Posted By Henri Mäntysaari 01-17-2022 04:46
Found In Egroup: Automate \ view thread
I believe Excel's limit for rows in a sheet is a bit over 1 000 000. Could this be the reason? ------------------------------ -- ------------------------------

RE: Transaction recording: exit using Save or Back

Posted By Henri Mäntysaari 01-13-2022 04:59
Found In Egroup: Automate \ view thread
Thanks for the reply.  Interesting. So validation does not go through the screen where Save is, and thus the last data tab will be completely left out if the save is there. Well, I don't need validation that often. I'm under the impression that OK codes are what define what happens after each data ...

RE: Transaction recording: exit using Save or Back

Posted By Henri Mäntysaari 01-12-2022 01:27
Found In Egroup: Automate \ view thread
Thank you for the reply. I'm glad to hear that I probably haven't messed up.  I understand how developers' personal preferences can affect ways of working, it's good to know that anything that works goes and there's no single truth.

Transaction recording: exit using Save or Back

Posted By Henri Mäntysaari 01-11-2022 07:17
Found In Egroup: Automate \ view thread
Hi Community I went through some old notes I had written down when I had my first training sessions when starting to use Winshuttle. In my notes there's a mention that when recording scripts that edit values in Material Master, exit from the transaction should be done using "Back", so that the save ...

RE: WS scripts: possible to include formula creation

Posted By Henri Mäntysaari 01-05-2022 06:46
Found In Egroup: Automate \ view thread
Thank you for your comments. So VBA means using an Excel Macro for accomplishing this. I understand what you mean, though for me being able to include it to a script would be the simpler solution: No need to create an another tool, no need for the runner to run anything separately. To me it feels more ...

WS scripts: possible to include formula creation

Posted By Henri Mäntysaari 01-04-2022 06:37
Found In Egroup: Automate \ view thread
Hi community! Is it possible to include Excel formula creation to transaction based script running? I know that it's possible to edit read data using formulas automatically, (Transform rule), but would it be possible to have the script add formulas to other cells as it works? A simplified but ...

RE: Excel Add-In asking me to save the data file

Posted By Henri Mäntysaari 10-29-2021 00:47
Found In Egroup: Automate \ view thread
Try pausing OneDrive's (or equivalent service's) syncing. It solved this for me. Right click the icon in system tray and choose pause from the menu. Then close all Excel windows and try again.