how to combine mutiple rows into one separated by ','? Form builder muti selection data handling

Options
ZoeZhou
ZoeZhou Member
in Magic ETL

I used form builder and there are couple fields are multisection dropdowns, in the response dataset, it separates the selections into different rows, but I want them to show as a,b,c together not a(next row), b(next row),c. Does anybody know how should I use the magic ETL to do that? I used my old way to transform the response data and it's only showing one value for the field.

For example, FS Team Members should be in one row and show as '1,3,5,7' Engineering Discipline show as 'Systems engineers, V&V', Sectors should show as 'Hospital Equipment, Drug Delivery'.

image.png

what I got in the reformed dataset is

image.png
image.png

This is the current Magic ETL

image.png

I believe I should do the combing rows before the pivot.

Tagged:

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓
    Options

    use a group by tile to combine your field with commas as your aggregation

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓
    Options

    use a group by tile to combine your field with commas as your aggregation

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Categories