Automate

Hello Winshuttle Community, 

I am currently working on a project about changing the General Data for Customers (XD02) using a Winshuttle Composer form solution. I am trying to figure out some joining issues when constructing the Query script in Studio in order to populate information of what is already in that t-code.

The challenge I am bringing to the community is how to use more than one outer join or a work around in order to use tables such as ADR3, ADR3, ADR6 with KNVK to get all of a contact person's information in one query based off a customer number. The problem with using only one outer join and the rest inner joins, if one table does not have a record with the key, nothing will pull through. 

If anyone knows how to get multiple outer joins or a work around in Studio, I would really appreciate it! This would help me avoid multiple query scripts and/or web services in Composer. 

Regards,

------------------------------
Jack Oxley | Master Data Intern
Dairy Farmers of America, Inc.
------------------------------

Hi Jack,
One way to get past this issue is to use multiple queries chained together. For example you can use filters on KNVK, get an output, and then use the exported list as an input for your second query (ADR3/6).

------------------------------
Isra Azam |
Exxon Mobil Corporation
------------------------------

Original Message:
Sent: 01-17-2020 14:58
From: Jack Oxley
Subject: Multiple Outer Joins in Studio

Hello Winshuttle Community,

I am currently working on a project about changing the General Data for Customers (XD02) using a Winshuttle Composer form solution. I am trying to figure out some joining issues when constructing the Query script in Studio in order to populate information of what is already in that t-code.

The challenge I am bringing to the community is how to use more than one outer join or a work around in order to use tables such as ADR3, ADR3, ADR6 with KNVK to get all of a contact person's information in one query based off a customer number. The problem with using only one outer join and the rest inner joins, if one table does not have a record with the key, nothing will pull through.

If anyone knows how to get multiple outer joins or a work around in Studio, I would really appreciate it! This would help me avoid multiple query scripts and/or web services in Composer.

Regards,

------------------------------
Jack Oxley | Master Data Intern
Dairy Farmers of America, Inc.
------------------------------

Isra,
Thank you for the suggestion. My next question is, can a chained Query script be used as a Webservice in Composer. At least with my experience with chained Query scripts, the transition from running one script to another requires some oversight and not just "run" by themselves. Is there any kind of documentation on using chained scripts and/or for a Composer web service?

------------------------------
Jack Oxley | Master Data Intern
Dairy Farmers of America, Inc.
------------------------------

Original Message:
Sent: 01-20-2020 08:54
From: Isra Azam
Subject: Multiple Outer Joins in Studio

Hi Jack,
One way to get past this issue is to use multiple queries chained together. For example you can use filters on KNVK, get an output, and then use the exported list as an input for your second query (ADR3/6).

------------------------------
Isra Azam |
Exxon Mobil Corporation

Original Message:
Sent: 01-17-2020 14:58
From: Jack Oxley
Subject: Multiple Outer Joins in Studio

Hello Winshuttle Community,

I am currently working on a project about changing the General Data for Customers (XD02) using a Winshuttle Composer form solution. I am trying to figure out some joining issues when constructing the Query script in Studio in order to populate information of what is already in that t-code.

The challenge I am bringing to the community is how to use more than one outer join or a work around in order to use tables such as ADR3, ADR3, ADR6 with KNVK to get all of a contact person's information in one query based off a customer number. The problem with using only one outer join and the rest inner joins, if one table does not have a record with the key, nothing will pull through.

If anyone knows how to get multiple outer joins or a work around in Studio, I would really appreciate it! This would help me avoid multiple query scripts and/or web services in Composer.

Regards,

------------------------------
Jack Oxley | Master Data Intern
Dairy Farmers of America, Inc.
------------------------------

Hi Jack

For web service execution, if order doesn't matter, you can trigger both via an action, like a button click, but if you want to maintain order, you have to use another rule. 

I usually have a rule on the logfield of the first script.  You can add a rule that says if it's not empty or contains a text string - like records extracted - then you run the next script.

Hope that helps,
Sigrid

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

Original Message:
Sent: 01-20-2020 09:28
From: Jack Oxley
Subject: Multiple Outer Joins in Studio

Isra,
Thank you for the suggestion. My next question is, can a chained Query script be used as a Webservice in Composer. At least with my experience with chained Query scripts, the transition from running one script to another requires some oversight and not just "run" by themselves. Is there any kind of documentation on using chained scripts and/or for a Composer web service?

------------------------------
Jack Oxley | Master Data Intern
Dairy Farmers of America, Inc.

Original Message:
Sent: 01-20-2020 08:54
From: Isra Azam
Subject: Multiple Outer Joins in Studio

Hi Jack,
One way to get past this issue is to use multiple queries chained together. For example you can use filters on KNVK, get an output, and then use the exported list as an input for your second query (ADR3/6).

------------------------------
Isra Azam |
Exxon Mobil Corporation

Original Message:
Sent: 01-17-2020 14:58
From: Jack Oxley
Subject: Multiple Outer Joins in Studio

Hello Winshuttle Community,

I am currently working on a project about changing the General Data for Customers (XD02) using a Winshuttle Composer form solution. I am trying to figure out some joining issues when constructing the Query script in Studio in order to populate information of what is already in that t-code.

The challenge I am bringing to the community is how to use more than one outer join or a work around in order to use tables such as ADR3, ADR3, ADR6 with KNVK to get all of a contact person's information in one query based off a customer number. The problem with using only one outer join and the rest inner joins, if one table does not have a record with the key, nothing will pull through.

If anyone knows how to get multiple outer joins or a work around in Studio, I would really appreciate it! This would help me avoid multiple query scripts and/or web services in Composer.

Regards,

------------------------------
Jack Oxley | Master Data Intern
Dairy Farmers of America, Inc.
------------------------------