Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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
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
Thank you Marco. It is really helpful.