Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Try this :
[Order Number] & ',' [Schedule Line Number] & ',' & [Material_Code] & ',' & [Material Name] & ',' & [Confirm Qty]
Kind regards,
Théo ATRAGIE.
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 |
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.
can you help me how can i write this query in the table
done
Thank you