topic Prevent table association without Qualify statement in App Development

Prevent table association without Qualify statement

lukenathan — Fri, 22 Jun 2018 02:39:42 GMT

Is there a way to prevent these two tables from associating other than Qualify and Unqualify statements?

Tbl1:

NoConcatenate

LOAD

"CategoryID",

"ProductID",

"QuantityPerUnit",

"SupplierID",

"ItemCost",

"ItemPrice",

"UnitsInStock",

"UnitsOnOrder",

"UnitCost",

"CurrentPrice",

"ProductName",

FROM [lib://SOP.xlsx]

(ooxml, embedded labels, table is [Products])

Where WildMatch([ProductName],'*Jacuzzi*');

Tbl2:

NoConcatenate

LOAD

"CategoryID",

"ProductID",

"QuantityPerUnit",

"SupplierID",

"ItemCost",

"ItemPrice",

"UnitsInStock",

"UnitsOnOrder",

"UnitCost",

"CurrentPrice",

"ProductName",

FROM [lib://SOP.xlsx]

(ooxml, embedded labels, table is [Products])

Where WildMatch([ProductName],'*Wine Glass*');

Re: Prevent table association without Qualify statement

Lisa_P — Fri, 22 Jun 2018 03:17:10 GMT

Hi Luke,

Can you explain what you are trying to do and why ?

Lisa

Re: Prevent table association without Qualify statement

ogautier62 — Fri, 22 Jun 2018 07:33:11 GMT

Hi,

why don't you create one unique table with one load and wildmatch with or ? !!!!

regards

Re: Prevent table association without Qualify statement

lukenathan — Sat, 23 Jun 2018 22:29:15 GMT

Hi Lisa, I want to add fields to Tbl1 and Tbl2 then create a new table with the contents from both. If I don't separate them to begin with I will not be able to add the field records that I want.

Re: Prevent table association without Qualify statement

lukenathan — Sat, 23 Jun 2018 22:30:13 GMT

Thanks Olivier sounds like a good idea. Can you show me what that would look like with this?

Tbl1:

NoConcatenate

LOAD

"CategoryID",

"ProductID",

"QuantityPerUnit",

"SupplierID",

"ItemCost",

"ItemPrice",

"UnitsInStock",

"UnitsOnOrder",

"UnitCost",

"CurrentPrice",

"ProductName",

FROM [lib://SOP.xlsx]

(ooxml, embedded labels, table is [Products])

Where WildMatch([ProductName],'*Jacuzzi*');

Tbl2:

NoConcatenate

LOAD

"CategoryID",

"ProductID",

"QuantityPerUnit",

"SupplierID",

"ItemCost",

"ItemPrice",

"UnitsInStock",

"UnitsOnOrder",

"UnitCost",

"CurrentPrice",

"ProductName",

FROM [lib://SOP.xlsx]

(ooxml, embedded labels, table is [Products])

Where WildMatch([ProductName],'*Wine Glass*');

Re: Prevent table association without Qualify statement

Lisa_P — Sat, 23 Jun 2018 23:06:51 GMT

What fields do you want to add ?

Re: Prevent table association without Qualify statement

marcus_sommer — Mon, 25 Jun 2018 07:02:52 GMT

It would be just:

Tbl1:

NoConcatenate

LOAD

"CategoryID",

"ProductID",

"QuantityPerUnit",

"SupplierID",

"ItemCost",

"ItemPrice",

"UnitsInStock",

"UnitsOnOrder",

"UnitCost",

"CurrentPrice",

"ProductName",

FROM [lib://SOP.xlsx]

(ooxml, embedded labels, table is [Products])

Where WildMatch([ProductName],'*Jacuzzi*', '*Wine Glass*');

- Marcus

Re: Prevent table association without Qualify statement

Lisa_P — Mon, 25 Jun 2018 22:51:15 GMT

Hi Marcus,

You only need to load the table once and you can put both criteria in the where at the end using like..

Tbl1:

LOAD

"CategoryID",

"ProductID",

"QuantityPerUnit",

"SupplierID",

"ItemCost",

"ItemPrice",

"UnitsInStock",

"UnitsOnOrder",

"UnitCost",

"CurrentPrice",

"ProductName",

FROM [lib://SOP.xlsx]

(ooxml, embedded labels, table is [Products])

Where ProductName like '*Jacuzzi*' or ProductName like '*Wine Glass*';