Store two seperate dynamic attributes in a single account customproperty

[SSinha_]

Hi team,

I have two dynamic attribute DA1 and DA2 on the request form, for service account. Is it possible to store the concatination of these two attributes in a single account customproperty?

Thanks.

[rushikeshvartak]

No its not supported OOTB, use enahcned query

[Amit_Malik]

Have you tried having another DA , something like 

Select concat(${DA1},' ', ${DA2}) as ID

Use account column  

[SSinha_]

Yes I tried this already but did not work

[NM]

@SSinha_ no supported .. create a seperate DA and store the combined value in one customproperty.

[SSinha_]

I tried concatinating but no query seems to be working , do you have any sample ones?

[Amit_Malik]

One screen shot showing that it is working. Another , with DA's settings.

[SSinha_]

One of my attributes is ENUM and other is SQL ENUM , is it working for those two?

[Amit_Malik]

Yes

[SSinha_]

For me it is only populating the value of parent attribute in DA3 i.e DA1 it is not concatinating the value of DA2

[Amit_Malik]

can you send the screen shot ? I have sent you screen shot of it working , hope you are using the configs as shared in screen shots 

[Amit_Malik]

I also had same issue earlier but after some hit and trial , I could make it work and have shared you the configs that are working

[rushikeshvartak]

It will not work with ENUM. both needs to be SQL ENUM

[Amit_Malik]

it is working for me. One is ENUM and another SQL ENUM