Concatenate two values in Field

[nihhalmca]

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 · Accepted solution]

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

[er_mohit]

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]

Thank You Gysbert

NiHhal.