Automate

Hello All,

I have a requirement to create a query where the same query needs to run 52 times to download functional location with use status and address for two plants with different inputs.(one sheet name will be A and all functional location starting with A, same up to Z)

Because of the authorization issue, we have to use just tables to create queries.

In one query, we have a limitation to put only one outer join. So created two different queries (one with address and another two pull address-comments and via lookup joining)

So two queries and the second query is taking input from the first query's sheet.

So I linked these two queries.

Now to automatically download 52 different sheets (just difference in name and parameter for functional location(A*,B* etc), I need to copy these scripts 52 times and linked.

So the requirement is to link, already linked script.

In that, I am getting as below 


Can you please suggest workaround here?




------------------------------
preeti aich | Asset and Maintenance Data Lead
Thames Water Utilities Ltd | 07747646346
------------------------------

Hi Preeti -

The character limit is a limitation. If one of your queries actually does exceed that number of characters, then you would need to change it so that it does not. 

https://support.winshuttle.com/hc/en-us/articles/360023442352-Error-Query-cannot-be-executed-because-the-query-length-exceeds-65536-characters

But I am guessing from what you wrote that you are using the Like operator for the FLOC numbers so that character limit should not be reached in that run. When are you getting this error?  Is your second query that uses the output from the first, doe that have an IN operator that exceeds this limit?  

Thanks

------------------------------
Jennifer Hwang | SE
Winshuttle North America
------------------------------

Original Message:
Sent: 07-29-2021 12:44
From: preeti aich
Subject: Query

Hello All,

I have a requirement to create a query where the same query needs to run 52 times to download functional location with use status and address for two plants with different inputs.(one sheet name will be A and all functional location starting with A, same up to Z)

Because of the authorization issue, we have to use just tables to create queries.

In one query, we have a limitation to put only one outer join. So created two different queries (one with address and another two pull address-comments and via lookup joining)

So two queries and the second query is taking input from the first query's sheet.

So I linked these two queries.

Now to automatically download 52 different sheets (just difference in name and parameter for functional location(A*,B* etc), I need to copy these scripts 52 times and linked.

So the requirement is to link, already linked script.

In that, I am getting as below


Can you please suggest workaround here?




------------------------------
preeti aich | Asset and Maintenance Data Lead
Thames Water Utilities Ltd | 07747646346
------------------------------

Original Message:
Sent: 7/30/2021 9:33:00 AM
From: Jennifer Hwang
Subject: RE: Query

Hi Preeti -

The character limit is a limitation. If one of your queries actually does exceed that number of characters, then you would need to change it so that it does not. 

https://support.winshuttle.com/hc/en-us/articles/360023442352-Error-Query-cannot-be-executed-because-the-query-length-exceeds-65536-characters

But I am guessing from what you wrote that you are using the Like operator for the FLOC numbers so that character limit should not be reached in that run. When are you getting this error?  Is your second query that uses the output from the first, doe that have an IN operator that exceeds this limit?  

Thanks

------------------------------
Jennifer Hwang | SE
Winshuttle North America
------------------------------

Original Message:
Sent: 07-29-2021 12:44
From: preeti aich
Subject: Query

Hello All,

I have a requirement to create a query where the same query needs to run 52 times to download functional location with use status and address for two plants with different inputs.(one sheet name will be A and all functional location starting with A, same up to Z)

Because of the authorization issue, we have to use just tables to create queries.

In one query, we have a limitation to put only one outer join. So created two different queries (one with address and another two pull address-comments and via lookup joining)

So two queries and the second query is taking input from the first query's sheet.

So I linked these two queries.

Now to automatically download 52 different sheets (just difference in name and parameter for functional location(A*,B* etc), I need to copy these scripts 52 times and linked.

So the requirement is to link, already linked script.

In that, I am getting as below


Can you please suggest workaround here?




------------------------------
preeti aich | Asset and Maintenance Data Lead
Thames Water Utilities Ltd | 07747646346
------------------------------

Hi Preeti -

If none of your queries exceed that character limit, then it would be best to open a Support ticket so they can help troubleshoot.

Thanks

------------------------------
Jennifer Hwang | SE
Winshuttle North America
------------------------------

Original Message:
Sent: 07-30-2021 09:39
From: preeti aich
Subject: Query

Hello Jennifer,

 

When second script is start running then after some mins but my query input just in thousand and never reaching that limit.

 

Thanks and Regards,

Preeti

 

Original Message:
Sent: 7/30/2021 9:33:00 AM
From: Jennifer Hwang
Subject: RE: Query

Hi Preeti -

The character limit is a limitation. If one of your queries actually does exceed that number of characters, then you would need to change it so that it does not.

https://support.winshuttle.com/hc/en-us/articles/360023442352-Error-Query-cannot-be-executed-because-the-query-length-exceeds-65536-characters

But I am guessing from what you wrote that you are using the Like operator for the FLOC numbers so that character limit should not be reached in that run. When are you getting this error?  Is your second query that uses the output from the first, doe that have an IN operator that exceeds this limit?

Thanks

------------------------------
Jennifer Hwang | SE
Winshuttle North America

Original Message:
Sent: 07-29-2021 12:44
From: preeti aich
Subject: Query

Hello All,

I have a requirement to create a query where the same query needs to run 52 times to download functional location with use status and address for two plants with different inputs.(one sheet name will be A and all functional location starting with A, same up to Z)

Because of the authorization issue, we have to use just tables to create queries.

In one query, we have a limitation to put only one outer join. So created two different queries (one with address and another two pull address-comments and via lookup joining)

So two queries and the second query is taking input from the first query's sheet.

So I linked these two queries.

Now to automatically download 52 different sheets (just difference in name and parameter for functional location(A*,B* etc), I need to copy these scripts 52 times and linked.

So the requirement is to link, already linked script.

In that, I am getting as below


Can you please suggest workaround here?




------------------------------
preeti aich | Asset and Maintenance Data Lead
Thames Water Utilities Ltd | 07747646346
------------------------------

Original Message:
Sent: 7/30/2021 9:44:00 AM
From: Jennifer Hwang
Subject: RE: Query

Hi Preeti -

If none of your queries exceed that character limit, then it would be best to open a Support ticket so they can help troubleshoot.

Thanks

------------------------------
Jennifer Hwang | SE
Winshuttle North America
------------------------------

Original Message:
Sent: 07-30-2021 09:39
From: preeti aich
Subject: Query

Hello Jennifer,

 

When second script is start running then after some mins but my query input just in thousand and never reaching that limit.

 

Thanks and Regards,

Preeti

 

Original Message:
Sent: 7/30/2021 9:33:00 AM
From: Jennifer Hwang
Subject: RE: Query

Hi Preeti -

The character limit is a limitation. If one of your queries actually does exceed that number of characters, then you would need to change it so that it does not.

https://support.winshuttle.com/hc/en-us/articles/360023442352-Error-Query-cannot-be-executed-because-the-query-length-exceeds-65536-characters

But I am guessing from what you wrote that you are using the Like operator for the FLOC numbers so that character limit should not be reached in that run. When are you getting this error?  Is your second query that uses the output from the first, doe that have an IN operator that exceeds this limit?

Thanks

------------------------------
Jennifer Hwang | SE
Winshuttle North America

Original Message:
Sent: 07-29-2021 12:44
From: preeti aich
Subject: Query

Hello All,

I have a requirement to create a query where the same query needs to run 52 times to download functional location with use status and address for two plants with different inputs.(one sheet name will be A and all functional location starting with A, same up to Z)

Because of the authorization issue, we have to use just tables to create queries.

In one query, we have a limitation to put only one outer join. So created two different queries (one with address and another two pull address-comments and via lookup joining)

So two queries and the second query is taking input from the first query's sheet.

So I linked these two queries.

Now to automatically download 52 different sheets (just difference in name and parameter for functional location(A*,B* etc), I need to copy these scripts 52 times and linked.

So the requirement is to link, already linked script.

In that, I am getting as below


Can you please suggest workaround here?




------------------------------
preeti aich | Asset and Maintenance Data Lead
Thames Water Utilities Ltd | 07747646346
------------------------------