Automate

Hi forum
For a given load script, I would like to validate certain data before load. As the script contains loops, this function does not work.

I therefore have an idea of adding a "preburner" sheet, where the end user can add the specific data and then have a query at the first step in a chain of scripts. If the query returns the requested data, they will be copied to the subsequent sheet.
Unfortunately, the data are not linked via tables (or infosets/logical databases). Eg Work center, Functional location and material master.

I assume that I have to chain specific queries for each table CRHD, IFLOT and MARC

Can you confirm this approach is the way to go?

Or has anyone solved the "query on several independent tables in one go" in any way?

I'm on Winshuttle 20.2.8

Br Michael

Hi forum
For a given load script, I would like to validate certain data before load. As the script contains loops, this function does not work.

I therefore have an idea of adding a "preburner" sheet, where the end user can add the specific data and then have a query at the first step in a chain of scripts. If the query returns the requested data, they will be copied to the subsequent sheet.
Unfortunately, the data are not linked via tables (or infosets/logical databases). Eg Work center, Functional location and material master.

I assume that I have to chain specific queries for each table CRHD, IFLOT and MARC

Can you confirm this approach is the way to go?

Or has anyone solved the "query on several independent tables in one go" in any way?

I'm on Winshuttle 20.2.8

Br Michael

Hi Sigrid

I will elaborate on the process. I have also attached an illustration.

The scenario is that end user wants to have new task lists (TL) and maintenance plans (MP) created in SAP. 
The end user gives information (Functional loc (Floc), Equipment (Eqm) and components for TL) to super user, who fills in the remaining data in the main load sheet load via Winshuttle into SAP.
To make life easier for super user (avoid load errors) we want the end user to check in advance, that the provided floc, eqm and comp actually exist in SAP. The end user is not supposed to load anything, thus it is not possible to validate any transaction. The super user cannot validate either as the load scripts contains parallel loops.
So my take on this was to let the end user run a query to verify the existence of the data or to catch any misspellings.

I made it work by chaining three individual query scripts.  If data exist (and downloaded to query sheet as a confirmation), they are subsequently copied from the query sheet to the main load sheets in the same excel workbook. The downside is if the data do not exist, the query silently returns nothing. I have handled this with conditional formatting. Then the end user will notice.
But if it could be made simpler, I would really like to do that :-)
Br Michael

Hi forum
For a given load script, I would like to validate certain data before load. As the script contains loops, this function does not work.

I therefore have an idea of adding a "preburner" sheet, where the end user can add the specific data and then have a query at the first step in a chain of scripts. If the query returns the requested data, they will be copied to the subsequent sheet.
Unfortunately, the data are not linked via tables (or infosets/logical databases). Eg Work center, Functional location and material master.

I assume that I have to chain specific queries for each table CRHD, IFLOT and MARC

Can you confirm this approach is the way to go?

Or has anyone solved the "query on several independent tables in one go" in any way?

I'm on Winshuttle 20.2.8

Br Michael