topic Re: nested concat on pivot table in App Development

nested concat on pivot table

shruthibk — Mon, 20 Dec 2021 21:38:40 GMT

Hi All,

I have a requirement to concat two fields to show in a pivot table.

Week, Category, title

1,beauty,Test1

1,beauty,Test2

1,Espresso,Test2

expected output

week 1

test1,test2(beauty),Test2(espresso)

Kindly help me with the concat function

Thanks,

Shruthi B K

Re: nested concat on pivot table

jaibau1993 — Mon, 16 Dec 2019 07:48:13 GMT

Hi!

Use something like the following as expression:

Concat(Distinct title & '(' & Category & ')')

Regards,

Jaime.

Re: nested concat on pivot table

shruthibk — Mon, 16 Dec 2019 08:49:37 GMT

the expression doesn't return the desired output

Re: nested concat on pivot table

shruthibk — Mon, 16 Dec 2019 08:51:31 GMT

the suggested expression is giving the output

test1(beauty),test2(beauty),Test2(espresso)

but expected output is

test1,test2(beauty),Test2(espresso)

Re: nested concat on pivot table

Anil_Babu_Samineni — Mon, 16 Dec 2019 11:31:56 GMT

What is the O/P you need from below table?

Week, Category, title

1,beauty,Test1

1,Espresso,Test2

1,beauty,Test1

1,Espresso1,Test2

Re: nested concat on pivot table

shruthibk — Mon, 16 Dec 2019 12:46:20 GMT

for week 1

Test1(beauty),Test2(Espresso,Espresso1)

Re: nested concat on pivot table

sunny_talwar — Mon, 16 Dec 2019 13:05:03 GMT

You can try this

=Concat(DISTINCT Aggr(Concat(DISTINCT title, ',') & '(' & Category & ')', Week, Category), ',')

Re: nested concat on pivot table

shruthibk — Mon, 16 Dec 2019 13:26:21 GMT

Thank you Sunny 🙂

Re: nested concat on pivot table

sunny_talwar — Mon, 16 Dec 2019 13:29:01 GMT

But this doesn't seem to work with the solution you provided to @Anil_Babu_Samineni updated sample.

Re: nested concat on pivot table

bixpahalley — Thu, 09 Sep 2021 07:59:50 GMT

you can try this, it's work.

=Concat(DISTINCT Aggr(Concat(DISTINCT title, ',') & '(' & Concat(DISTINCT Category,',') & ')', Week, Category), ',')