This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
When choosing a new physician, what information is most important to you
@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.