Multiple dimension values in one cell. How to filter it?

[evgeniystuchalk]

Hello! I have table like this:

Deal ID	Tags
1	tag1, tag2
2	tag2
3	tag2,tag3,tag4
4	tag5

after loading, i want to see in Filter for Tags field values like:

tag1

tag2

tag3

tag4

tag5.

Not

tag1, tag2

tag2,tag3,tag4

etc.

It is real to make it?

[sunny_talwar · Accepted solution]

Try like this:

LOAD [Deal ID],

          SubField(Tags, ',') as Tags

FROM Source;

[evgeniystuchalk]

Thanks! It works. But now i have next situation.

Earlier my Deals record looks like this:

Deal ID	Tags	Sum
1	tag1, tag2	500

And after subfield(Tags,', ') it looks like this:

Deal ID	Tags	Sum
1	tag1	500
1	tag2	500

What kind of set analysis i need to apply for measure Income, that takes sum of all Sum fields with distinct deals ID?

[sunny_talwar]

May be try this:

Sum(Aggr(Only(Sum), [Deal ID]))

or

Sum(Aggr(Avg(Sum), [Deal ID]))

or

Sum(Aggr(Sum(DISTINCT Sum), [Deal ID]))