topic Re: Custom category for products in App Development

Custom category for products

Tenuki — Tue, 29 Jul 2025 08:07:50 GMT

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 ?

Re: Custom category for products

JHuis — Tue, 29 Jul 2025 09:11:15 GMT

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.

Re: Custom category for products

Tenuki — Tue, 29 Jul 2025 09:19:27 GMT

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 🙂

Re: Custom category for products

JHuis — Tue, 29 Jul 2025 09:40:11 GMT

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

Re: Custom category for products

Tenuki — Tue, 29 Jul 2025 10:01:20 GMT

It worked, I just forgot to rename my field.

Thank you