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.
Summarize tool has a concatenation function to do what I think you're looking for.
@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.
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
@jrgo That did. Thank you. Appreciate it greatly!