Forum Discussion
combining multiple rows into 1
I'm importing a JSON file. When I expand the data, its taking a field (Dev_Exp) which allows the user to select mulitple boxes, and Its putting the response into seperate rows (ie: Front end, Back en...
AllisonKennedy Thank you for your response. I'd like to combine them and not use a measure. This doesn't affect all users, just some. I'd like to combine the values to show back in the 1 field. As a work around, I did export the API feed to an excel file, which puts all values from the field to 1 cell, and imported that. It sounds like I may have to go back to the dev team and see if there is a way for the data to be saved. . I will try the "group by" function.
jtpiazzamn How did you get on with the Group By function?
Also, why do you need it as a column and not a measure? That may help guide what further advice or workarounds we can suggest.