topic Re: Advance search in a string to map multiple values in QlikView

Advance search in a string to map multiple values

rahulgoyal1287 — Wed, 25 Nov 2020 16:16:04 GMT

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_C	Calc_Reason
Access Type Change	Access Type Change
Access type change, POP Details change	Access Type Change
Access type change, POP Details change	POP Details change
POP Details change, Interface/connector change	POP Details change
POP Details change, Interface/connector change	Interface/connector change

Re: Advance search in a string to map multiple values

MarcoWedel — Mon, 16 Apr 2018 20:12:16 GMT

Hi,

maybe one solution could be:

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

Re: Advance search in a string to map multiple values

rahulgoyal1287 — Tue, 17 Apr 2018 05:02:21 GMT

Thank you Marco. It is really helpful.