How can I merge data in many fields into 1 simple table | XM Community
Solved

How can I merge data in many fields into 1 simple table

Y
To whom may be concern,

I want to merge data from 3 fields that have the same answer and question into 1 simple table.
I can do separate 1 field for 1 table but when I group 3 fields the table data was not correct.

Best regards,

Yuwadi Otaravanna
icon

Best answer by JenCX 25 June 2019, 16:42

View original

2 replies

JenCX
Rank
Userlevel 7
Badge +11
Good morning! What I would suggest doing is to create a fourth field with embedded data. In your survey flow, use branch logic to check if each of your three similar questions are answered and if so, fill the embedded data field with the answer. Then, use the embedded data field in your reports and hide the other three.
Y
Dear JenCX,

Thanks for your kind. But I have a problem if three field have an answer and not the same answer such as field 1 answer A field 2 answer B and field 3 answer C... How can I do that..

Leave a Reply


Terms & Conditions