Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

rahulgoyal1287
New Contributor III

Advance search in a string to map multiple values

Hi Folks,

Thanks for sparing some time to help me here.

Here is the problem statement where I am stuck with and looking for some help to move forward.

I have one field 'Description_C' which has some values in it (these are various reasons separated by coma) -

Access type change

Access type change, POP Details change

POP Details change, Interface/connector change

I would need to map these reasons in an another column 'Calc_Reason' under some category. For example -

so these above 3 entries would result into 5 combination of mapping values as stated below:

Description_CCalc_Reason
Access Type ChangeAccess Type Change
Access type change, POP Details changeAccess Type Change
Access type change, POP Details changePOP Details change
POP Details change, Interface/connector changePOP Details change
POP Details change, Interface/connector change

Interface/connector change

1 Solution

Accepted Solutions

Re: Advance search in a string to map multiple values

Hi,

maybe one solution could be:

QlikCommunity_Thread_298314_Pic1.JPG

table1:

LOAD Distinct

     Description_C,

     Trim(SubField(Description_C,',')) as Calc_Reason

FROM [https://community.qlik.com/thread/298314] (html, codepage is 1252, embedded labels, table is @1);

hope this helps

regards

Marco

2 Replies

Re: Advance search in a string to map multiple values

Hi,

maybe one solution could be:

QlikCommunity_Thread_298314_Pic1.JPG

table1:

LOAD Distinct

     Description_C,

     Trim(SubField(Description_C,',')) as Calc_Reason

FROM [https://community.qlik.com/thread/298314] (html, codepage is 1252, embedded labels, table is @1);

hope this helps

regards

Marco

rahulgoyal1287
New Contributor III

Re: Advance search in a string to map multiple values

Thank you Marco. It is really helpful.

Community Browser