Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
suhascool1
Contributor III
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)
2 Solutions

Accepted Solutions
theoat
Partner - Specialist
Partner - Specialist

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.

View solution in original post

suhascool1
Contributor III
Contributor III
Author

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

 

View solution in original post

5 Replies
theoat
Partner - Specialist
Partner - Specialist

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

Kind regards,
Théo ATRAGIE.

suhascool1
Contributor III
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
 
theoat
Partner - Specialist
Partner - Specialist

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.

suhascool1
Contributor III
Contributor III
Author

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

 

suhascool1
Contributor III
Contributor III
Author

done

Thank you