Custom category for products

[Tenuki]

Hello, I would like to create a group for products based on different conditions, linked to differents tables linked to my products.

For instance I create a table like this :

ProductCategory1:

LOAD 

ProductID,

    'ArticleCategory1'

FROM SuppliersProduct

WHERE LinkedSupplier = 'X'

AND SupplierID = 500

;

Then I load my product table with the ProductID to make the link.
This create differents fields based on my customs tables.

How to have only one field, grouping the customs categories ?

[JHuis]

I hope i got it right but you have to this i think:

ProductCategory:

LOAD 

ProductID,

    'ArticleCategory1' as ArticleCategory

FROM SuppliersProduct

WHERE LinkedSupplier = 'X'

AND SupplierID = 500;

Concatenate(ProductCategory)

LOAD 

ProductID,

    'ArticleCategory2' as ArticleCategory

FROM SuppliersProduct

WHERE LinkedSupplier = 'B'

AND SupplierID = 600;

etc. 

[Tenuki]

I have multiple table to link, one is coming from excel file

My tables look like this :

Table1 :

LOAD ProductID, PreparationTime, 'Seafood'

FROM Seafood.xlsx;

Table2 : 

LOAD ProductID, 'ChineeseProduct'

FROM SuppliersProduct

WHERE 

LinkedSupplier = 'B'

AND SupplierID = 600;

ProductTable:

ProductID, ProductName...

FROM Products

SalesDetails:

SalesLineID, SalesOrderID, ProductID, Amount as Revenue...

FROM Sales

Thanks for your help 🙂

[JHuis · Accepted solution]

Concatenate is creating one table from multiple tables. 

This will work i think

ProductTable:

LOAD ProductID, PreparationTime, 'Seafood'  as ProductCategory,

FROM Seafood.xlsx;

Concatenate(ProductTable) 

LOAD ProductID, 'ChineeseProduct' as ProductCategory,

FROM SuppliersProduct

WHERE 

LinkedSupplier = 'B'

AND SupplierID = 600;

ProductTable:

ProductID, ProductName...

FROM Products

SalesDetails:

SalesLineID, SalesOrderID, ProductID, Amount as Revenue...

FROM Sales

[Tenuki]

It worked, I just forgot to rename my field.

Thank you