Insight (OBIEE) --> How can I join several fields in one column without using concat()
My problem originates from within the Eloqua environment, since in the custom data object my team and I have five different fields that are collecting the same information (i.e. same picklist) per our client's request. Nonetheless, the client also wants to create an analysis in which one single column collects all five fields instead of one column per field. How can I join these columns without concatenating the answer?
I am asking because our client wants us to calculate the number of times an answer in the picklist is selected but because there are five fields contacts can select more than one option.