Category
Report Builder
Product Version
8.0
Splitting Data Using a Delimiter
Answered
In our reports we have a field that is populated by a picklist multiple so the data in that field comes through as ["Value 1", "Value 2"]. Is there a way to separate the data in that field so it populates as 2 rows instead of 1? E.g. Value 1 in the first row and then Value 2 in the 2nd row?
The same question
Hello Katherine,
Thank you for contacting Yellowfin Support.
Could you please provide the following details to help you further:
Regards.
Priya Chegudi.
Hello Katherine,
Thank you for contacting Yellowfin Support.
Could you please provide the following details to help you further:
Regards.
Priya Chegudi.
Hi Priya,
We're using version 8.0.11.1 and it's just a normal field coming from our source data, not a calculated field.
Thanks,
Katherine
Hi Priya,
We're using version 8.0.11.1 and it's just a normal field coming from our source data, not a calculated field.
Thanks,
Katherine
Hello Katherine,
I hope you are doing well.
Unfortunately, this is not possible to separate the data in that field so data populates as 2 rows instead of 1. To split the source data you may change this from your database. Please revert back if you have any further queries we are happy to assist.
Regards,
Priya Chegudi.
Hello Katherine,
I hope you are doing well.
Unfortunately, this is not possible to separate the data in that field so data populates as 2 rows instead of 1. To split the source data you may change this from your database. Please revert back if you have any further queries we are happy to assist.
Regards,
Priya Chegudi.
Hi Priya,
What about columns instead of rows?
Thanks,
Kate
Hi Priya,
What about columns instead of rows?
Thanks,
Kate
Hello Katherine,
I hope you are doing well.
Unfortunately, this is not possible to separate data of a single set into 2 columns or 2 rows . To split the source data you may change this from your database. Please revert back if you have any further queries we are happy to assist.
Regards,
Priya Chegudi
Hello Katherine,
I hope you are doing well.
Unfortunately, this is not possible to separate data of a single set into 2 columns or 2 rows . To split the source data you may change this from your database. Please revert back if you have any further queries we are happy to assist.
Regards,
Priya Chegudi
Hello Katherine,
I hope you are doing well.
I just wanted to double-check to see if you require any assistance with this, If not I will go ahead and mark this as completed.
I would appreciate hearing your comments.
Regards,
Priya Chegudi.
Hello Katherine,
I hope you are doing well.
I just wanted to double-check to see if you require any assistance with this, If not I will go ahead and mark this as completed.
I would appreciate hearing your comments.
Regards,
Priya Chegudi.
Hello Katherine,
I hope you are doing well.
I just want to touch base to see if you had a chance to read through my response. If you can let me know that would be great.
Thank you!
Regards,
Priya Chegudi.
Hello Katherine,
I hope you are doing well.
I just want to touch base to see if you had a chance to read through my response. If you can let me know that would be great.
Thank you!
Regards,
Priya Chegudi.
Hello Katherine,
I hope you are doing well.
I hope I have answered all your questions with regards to this case. It's been 5 days since I heard from you, because of age and inactivity I am going to go ahead and mark this as Completed, however, please feel free to re-open this ticket if you need any further assistance. I would be more than happy to assist where I can.
Regards,
Priya Chegudi.
Hello Katherine,
I hope you are doing well.
I hope I have answered all your questions with regards to this case. It's been 5 days since I heard from you, because of age and inactivity I am going to go ahead and mark this as Completed, however, please feel free to re-open this ticket if you need any further assistance. I would be more than happy to assist where I can.
Regards,
Priya Chegudi.
Replies have been locked on this page!