Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You can use a calculated dimension: =if(match(Product,'A','B'),'AB',Product). See attached example.
You can use a calculated dimension: =if(match(Product,'A','B'),'AB',Product). See attached example.
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;
Thank You Gysbert
NiHhal.