Need Help in Concat Function

[Anonymous]

Hello  ! pls. help me compose formula in concatinating items

Fruits                  Description     Desired New field

Apple                 red                   red/sweet/round

Apple                 sweet                red/sweet/round

Apple                  round               red/sweet/round

Banana              yellow                yellow/long/sweet/fresh 

Banana              long                   yellow/long/sweet/fresh

Banana              sweet                   yellow/long/sweet/fresh

Banana              fresh                  yellow/long/sweet/fresh

Orange               sour                sour

I'd like to concat all the item in description field  of a certail Fruit...pls. see my desired outpu in red text.

Tks.

[#2]

Check the attached QVW

[#3]

Sorry, I took the liberty of assuming you only wanted to show the three rows in your table haha.  Hope that works for you!

[#4 · Accepted solution]

Attached with answer. Used Robert's file and made some changes to it. Calculations are done in the script(back-end)

Thanks

[maxgro]

you can make a chart with

dimensions

- Fruits

- Description

expression

- concat(TOTAL <Fruits> Description, '/')

[MarcoWedel]

Hi,

one example:

tabFruits:
LOAD * INLINE [
    Fruits, Description
    Apple, red
    Apple, sweet
    Apple, round
    Banana, yellow
    Banana, long
    Banana, sweet
    Banana, fresh
    Orange, sour
];

tabFruitSummary:
LOAD Distinct
  Fruits,
  Concat(Description, '/', RecNo()) as [Desired New field]
Resident tabFruits
Group By Fruits;

hope this helps

regards

Marco

[Anonymous]

Thank you, Ajay...it worked.