Concat Column into one Row

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!

Workflow

Tips and Tricks

Preparation

Accepted answers

jrgo

@bryan_ram2613

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

bryan_ram2613.yxmd

All comments

jrgo

Hi @bryan_ram2613

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.

Jimmy
Teknion Data Solutions

nitinsnow

Concat.yxzp

bryan_ram2613

@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.

Poll_Example.yxdb

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703