topic Re: Categorize the data using sub field in QlikView

Categorize the data using sub field

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

Hi,

I have a field called 'Product ID' as below.

If the field values is end with 7539 we need to name it as ProductA and if field values is end with 17973 we need to name it as ProductB.

Thanks..

Peter_Cammaert — Tue, 21 Aug 2018 06:43:04 GMT

How about

LOAD ...

[Product ID],

Pick(Match(SubField([Product ID], '-', -1), '7529', '17973'), 'ProductA', 'ProductB') AS [Product Name],

...

FROM ...;

Your example contains only two cases. If you need to translate a large(r) number of Product IDs, then use a Mapping Table instead of Pick/Match.

Best,

Peter

chinnuchinni — Tue, 21 Aug 2018 06:47:37 GMT

try this in script:

if(right(Product_ID,4)='7539','prod_A',if(right(Product_ID,5)='17973 ','prod_B','Prod_C')) as Prod

ChennaiahNallani — Tue, 21 Aug 2018 06:48:54 GMT

try like below

subfield(Fieldname, '-', 1) as ProductB,

subfield(Fieldname, '-', 2) as ProductA ,