topic Re: Concatenate two values in Field in QlikView

Concatenate two values in Field

nihhalmca — Wed, 03 Jul 2013 12:19:18 GMT

Hi Experts,

I got one requirement that have to concatenate two values in a field

For ex:

Product Qty

A 10

B 20

C 25

D 30

I need to add A and B means my result should be...

Product Qty

AB 30

C 25

D 30

Please let me know solution

Thanks in Advance

Nihhal.

Gysbert_Wassenaar — Wed, 03 Jul 2013 12:25:22 GMT

You can use a calculated dimension: =if(match(Product,'A','B'),'AB',Product). See attached example.

er_mohit — Wed, 03 Jul 2013 13:11:45 GMT

Try this

AS:

LOAD if(WildMatch(Product,'A','B'),'AB',Product) as Prouct,* Inline [

Product, Qty

A , 10

B , 20

C , 25

D , 30

];

noConcatenate

LOAD Prouct, sum(Qty) as Quantity

Resident AS

Group by Prouct;

DROP Table AS;

nihhalmca — Thu, 27 Feb 2014 06:09:50 GMT

Thank You Gysbert

NiHhal.