Concat Column into one Row
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi all,
I have a poll dataset that is formatted in a somewhat annoying way. How can I concat all of the following responses in the "When choosing a new physician, what information is most important to you?" column into one row separated by a comma.
Source | Doctor ID | Device | When choosing a new physician, what information is most important to you |
https://www.thechristhospital.com/physician-details?Provider=C21Q0VFETR | C21Q0VFETR | desktop | Practice location(s) |
Education | |||
Reviews/ratings | |||
Insurances accepted | |||
Years of experience | |||
Accepting new patients |
Thanks for the assistance!
Solved! Go to Solution.
- Labels:
- Preparation
- Tips and Tricks
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Summarize tool has a concatenation function to do what I think you're looking for.
Select your field you wish to concatenate and add using the option shown here
In your concatenated field, use these options to specify how to concatenating.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@jrgoand @nitinsnow I have tried this but I am running into errors because I have the same use case happening multiple times throughout the data set and it groups the blanks rows together. I attached an example file.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
See if the attached solution solves the issue. The YXDB you provided looks like it used a record as the headers so i copied the results into a text input tool using the default headers, i.e. Field1, Field2, etc...
Multi-Row tool is used to fill down the ID in the first column which is used as the grouping field within the Summarize tool. for the other fields, i just kept the FIRST and then concatenated that last field.
Jimmy
Teknion Data Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@jrgo That did. Thank you. Appreciate it greatly!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
