De-concatenating a multi select field on yellwofin report level
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???
Kindly mark this question as PRIVATE.
Regards,
Sonu
The same question
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
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
Hi Sonu,
Just checking in on this ticket to see if you need anything else?
Regards,
Paul
Hi Sonu,
Just checking in on this ticket to see if you need anything else?
Regards,
Paul
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,
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,
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
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
Hi Sonu,
No problems at all. Just get back in touch if you need anything else.
Thank you,
Paul
Hi Sonu,
No problems at all. Just get back in touch if you need anything else.
Thank you,
Paul
Replies have been locked on this page!