Hi . Can you please suggest a solution to solve this ?
table : categories | ||
id | tag | tag_ids |
1 | man | 102 |
2 | women | 103 |
3 | child | 105 |
I would like to end up with:
table : product | |||
id | product | tag | tag_ids |
1 | A | man|women | 102|103 |
2 | B | man|women|child | 102|103|105 |
3 | C | woman | 103 |
I tried LOOKUP formula but it works to return only one value , what about multiple values splited by "|" sign ??
Thank you
So I assume these are 2 seperate tables...
In the second table you're going to have to setup [Tag] and [Tag_IDs] as ENUMLIST type columns. Then have a formula for [Tag_IDs] as
Select(Table1[Tag_IDS],IN([Tag],[_ThisRow].[Tag])
Simon, 1minManager.com
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |