De-concatenating a multi select field on yellwofin report level

Sonu shared this question 7 months ago
Answered

Hi,

I am working on a report with multi select field which concatenates various values and separates them with a semi-colon.

Is there a way in the report builder to de-concatenate them and add them in separate rows???

/A5+khb0p2LsEAAAAAElFTkSuQmCC


Kindly mark this question as PRIVATE.


Regards,

Sonu

Comments (5)

photo
1

Hi Sonu,

The only way you could achieve this would by either an SQL Calculated field basis or via Yellowfin's Transformation steps, which would most likely be the best way forward. You can find more information on the transformation process here. You might want to look into the split, find/replace or substring function in the guide.

The calculated field might also be possible, but depending on the DB, will vary the query you would need to use and the only options I could think of which may work would be functions like split or substring, but either way, it will require a lot of trial and error with such a long string.

Regards,

Paul

photo
1

Hi Sonu,

Just checking in on this ticket to see if you need anything else?

Regards,

Paul

photo
1

Hi Sonu,

Hope you're having a good week.

Just wanted to check-in and see how it's all going. Was there anything you were needing from me to help get this resolved?

Regards,

photo
1

Hi Paul,


Thanks. I need to try these options and see how I go. We can close this ticket for now. I'll get in touch if I have any questions.


Regards,

Sonu

photo
1

Hi Sonu,

No problems at all. Just get back in touch if you need anything else.

Thank you,

Paul