topic Re: combine value in the new column in App Development

combine value in the new column

suhascool1 — Fri, 16 Feb 2024 12:06:37 GMT

Hi,

how to join the data in the combo column.

Order Number	Schedule Line Number	Material_Code	Material Name	Confirm Qty	Combo Coloumn
1234	2	10C39	Wooden Box	2	1234,2,10C39,Wooden Box,2
1234	1	10C39	Wooden Box	0	1234,1,10C39,Wooden Box,0
3456	2	39C34	Glass	1	3456,2,39C34,Glass,1
3456	1	39C34	Glass	0	3456,1,39C34,Glass,0
9805	2	56C34	Cotton	5	9805,2,56C34,Cotton,5
9805	1	56C34	Cotton	0	9805,1,56C34,Cotton,0

Thanks

suhas

Re: combine value in the new column

theoat — Fri, 16 Feb 2024 12:13:06 GMT

Try this :
[Order Number] & ',' [Schedule Line Number] & ',' & [Material_Code] & ',' & [Material Name] & ',' & [Confirm Qty]

Kind regards,
Théo ATRAGIE.

Re: combine value in the new column

suhascool1 — Fri, 16 Feb 2024 12:33:25 GMT

Hi Theot

Create new column in the existing table like this

Order Number	Schedule Line Number	Material_Code	Material Name	Confirm Qty
1234	2	10C39	Wooden Box	2
3456	2	39C34	Glass	1
9805	2	56C34	Cotton	5

and this new column Combo column and join value in the column

Combo Coloumn

1234,2,10C39,Wooden Box,2

3456,2,39C34,Glass,1

9805,2,56C34,Cotton,5

Re: combine value in the new column

theoat — Fri, 16 Feb 2024 12:43:40 GMT

Yes, this formula do this :
[Numéro de commande] & ',' [Numéro de ligne de programme] & ',' & [Code_matériau] & ',' & [Nom du matériau] & ',' & [Confirmer la quantité]

You can try this in a table where.

Have a nice day.
Kind regards,
Théo ATRAGIE.

Re: combine value in the new column

suhascool1 — Mon, 19 Feb 2024 06:00:15 GMT

can you help me how can i write this query in the table

Re: combine value in the new column

suhascool1 — Mon, 19 Feb 2024 08:15:40 GMT

done

Thank you