Skip to Content
0

Breaking down values of a column in UDT

May 08, 2017 at 06:50 PM

19

avatar image
Former Member

I have a customer type column that gives different account types a customer has in a single row separated by pipe character.

I want to know if there is a way to split these values at universe level and make an object with list

Ex:
Actual Data:
Customer Name: Account Type
ABCD: Savings | Credit Card | Mortgage | Car Loan
XYZ: Car Loan | Credit Card | Checking

Assumptions: Account Types order can change (based on age of the account); all customers may not have all types of accounts.

Requirement:
Customer Type object with LOV's -
Savings
Credit Card
Mortgage
Car Loan
Checking

so that users can filter the report by the Customer Type

Assumption: 1) Users will only filter 1 type of customer while running the report
2) Customers with 2 account types should appear in the report when it's run with either one value selected

I tried using substr() & pos() functions but, its not giving correct values as I'm not able to give correct lengths after the '|' symbol

Any help with regards to this is highly appreciated

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers