Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for
Did you mean:
Contributor III

## combine value in the new column

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

Labels (1)
• ### General Question

2 Solutions

Accepted Solutions
Partner - Creator III

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.

Contributor III
Author

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

5 Replies
Partner - Creator III

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

Kind regards,
Théo ATRAGIE.

Contributor III
Author

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
Partner - Creator III

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.

Contributor III
Author

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

Contributor III
Author

done

Thank you