
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Concatenating Multiple Values of a Field
Hi,
I am wanting to concatenate multiple 'MRP D/C Dates' into one cell in order to only have 1 row per member in my pivot table. In my example there are only 2 dates, but there can be more than that. I have tried creating variables and combining those but that gives me errors in my calculated dimension. For instance, in the below example I would like to see '11/28/2016, 3/29/3016' in one row rather than it creating 2.
Any help is appreciated!
- « Previous Replies
-
- 1
- 2
- Next Replies »
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
My bad, replace and with a comma
Aggr(Concat(DISTINCT {<MeasureID = {'MRP'}, Gap = {'>0'}>} EVENT_DATE, ','), MEM_ID)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello
Maybe
load
Concat(MRP D/C Dates,' ') as MRP D/C Dates
Resident Table;

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
did you try with the concat function?
concat(yourdatefield, ',')


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
= Concat('MRP D/C Dates', ',')

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have tried that and am getting "// Error in calculated dimension."

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have tried that and am getting "// Error in calculated dimension."


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you paste your calculated dim expression here you are using?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sure. Here is a screenshot actually.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you try like:
= Aggr(Concat(DISTINCT EVENT_DATE, ','), EVENT_DATE)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you. I think I am getting there. I tried Aggr(Concat(DISTINCT EVENT_DATE, ','), MEM_ID) and that concatenated all of the event dates as it should. However, I am only needing to concatenate event dates where MeasureID = 'MRP' and Gap >0. I tried =if(match(MeasureID, 'MRP_MRP') and Gap > 0, Aggr(Concat(DISTINCT EVENT_DATE, ','), MEM_ID)) and it did not work. Your help is appreciated!

- « Previous Replies
-
- 1
- 2
- Next Replies »