Advance search in a string to map multiple values

[rahulgoyal1287]

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

[MarcoWedel · Accepted solution]

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

[rahulgoyal1287]

Thank you Marco. It is really helpful.