Identifying if a list item is a property on a separate list

Highlighted
Occasional Contributor

Identifying if a list item is a property on a separate list

Hi,

I have two numbered lists, City and Product.

Product has City as a property.

All Products have a City as a property, and multiple Products can have the same City as a property, but not all Cities may be linked with a Product.

In a module with City list as a dimension, how could I identify if a City has been linked with a Product (it doesn't matter if it's one or many)?

Thanks,

2 REPLIES
Contributor

Re: Identifying if a list item is a property on a separate list

HI Ceri,

 

You can bring it in this way. Please follow the steps below.

 

Step 1: In your Product list add a number formatted line item and make it as 1 in the forumula

 

Identifying if a list item is a property on a separate list.PNG

 

 

Step 2 : In your module just do refer the above property(Count) by putting SUM:Country list property and you will get the count as no.of products and if it is 0 then that City is not linked to any Products. In my example "Chennai" city is not linked to any of the products.

Identifying if a list item is a property on a separate list 1.PNG

Hope this confirms your requirement. Let me know if you have any concerns.

 

Thanks,

Kavin.

 

Regular Contributor

Re: Identifying if a list item is a property on a separate list

The above will work, but please don't put those line items in a list, put them in a Module as this will help performance, will help with the general understanding and maintaining of the model, as well as show up on the Model Map (list properties do not show up on the model map).

 

Thanks,

 

Rob