Mapping one Field to multiple values?

aswinnar — Sat, 16 Nov 2024 00:26:30 GMT

Hi All,

I have a requirement in my application where I need to be able to map products to a particular market. Right now we have two Markets, Market M and Market N.

For my products A, B, C I need to map to Market M and Market N. Product B belongs to both Market M and Market N.

Product	Market
A	M
B	M
B	N
C	N

I have used applymap function to map the products to the market, however for Product B I am only getting Market M as a result. It is not mapping to Market N as well. Is there a way I can map to both markets? Is there another function that I would have to use?

Re: Mapping one Field to multiple values?

Vegar — Sat, 13 Mar 2021 09:24:42 GMT

I would consider to keep the Product-Market table as a dimension table in your data model that is associated with your Product field.

If that is not a solution that fits you then you would need to look at the concept of join.

Something like this.

LOAD * FROM MainTable;

Left join Product, Market FROM ProductMarketSource;

Please observe that if you are joining two markets to a Product row then you will end up with two Product rows, one per Market.

topic Mapping one Field to multiple values? in App Development

Mapping one Field to multiple values?

Re: Mapping one Field to multiple values?