function CONCATENATE with alternating values

[bolognesiedalla]

what formula do you recommend to concatenate the [PRODUCT] and [DOSAGE] values ​​in a alternated way?

I can get

PRODOCT1, PRODUCT2, PRODUCT3, DOSAGE1, DOSAGE2, DOSAGE3

but how do i get this?

DOSAGE1 PRODOCT1, DOSAGE2 PRODUCT2, DOSAGE3 PRODUCT3

As you can see, in field INTERVENTI[Related Product], with the formula set I do not get the desired result for 2 reasons:

1. I get the code, not the name. (the field RIGHE INTERVENTI[PRODOTTO] is a ref of the table PRODOTTI)

2. I'm not getting dosages alternating with the product name.

How can I improve it?

[Suvrutt_Gurjar · Accepted solution]

If understanding of your requirement is correct, please create a VC in your child table RIGHE INTERVENTI called say [Dosage Product] with an expression something like CONCATENATE([Dosage], " ",[Product Name])

Please ensure you use product name and not key in the above concatenated column.

Now you could get the combination in your INTERVENTI table by using expression

[Related RIGHE INTERVENTI][Dosage Product]