Prevent table association without Qualify statement

[lukenathan]

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*');

[Lisa_P]

Hi Luke,

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

Lisa

[ogautier62]

Hi,

Hi,

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

regards

[lukenathan]

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.

[lukenathan]

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*');

[Lisa_P]

What fields do you want to add ?

[marcus_sommer]

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

[Lisa_P]

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*';