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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2014-02-13 05:00 AM

Concatenate Rows

Hi every one we have a typical requirement We have following data

User IDNameDevice
80004022ABDUL AZAM868438010471186
80004022ABDUL AZAM868438010471186A
80001571ABDUL AZIZ868438010470071
80001571ABDUL AZIZ868438010470071A
80001571ABDUL AZIZ868438010470071B
80001594AKHLAQ AHMED868438010470147
80001594AKHLAQ AHMED868438010470147A
80001594AKHLAQ AHMED868438010470147B
80001594AKHLAQ AHMED868438010470147C
80001591ASIM IQBAL868438010471145
80001591ASIM IQBAL868438010471145A
80001591ASIM IQBAL868438010471145B
80001591ASIM IQBAL868438010471145C
80001705IMRAN UL HASSAN868438010464702
80001705IMRAN UL HASSAN868438010464702A
80001705IMRAN UL HASSAN868438010464702B
80006221MUHAMMAD AHMED KHAN868438010467937
80006221MUHAMMAD AHMED KHAN868438010467937A
80001703RAJA TALLET IMTIAZ868438010463480
80001703RAJA TALLET IMTIAZ868438010463480A
80001703RAJA TALLET IMTIAZ868438010463480B
80000756RIZWAN MALIK868438010471046
80000756RIZWAN MALIK868438010471046A
80000745SHOUKAT IQBAL868438010465857
80000745SHOUKAT IQBAL868438010465857A

We want to show User wise all devices in one row like below

User IDNameDevices
80004022ABDUL AZAM868438010471186, 868438010471186A
80001571ABDUL AZIZ868438010470071, 868438010470071A, 868438010470071B
80001594AKHLAQ AHMED868438010470147, 868438010470147A, 868438010470147B, 868438010470147C
80001591ASIM IQBAL868438010471145, 868438010471145A, 868438010471145B, 868438010471145C
80001705IMRAN UL HASSAN868438010464702, 868438010464702A, 868438010464702B
80006221MUHAMMAD AHMED KHAN868438010467937, 868438010467937A
80001703RAJA TALLET IMTIAZ868438010463480, 868438010463480A, 868438010463480B
80000756RIZWAN MALIK868438010471046, 868438010471046A
80000745SHOUKAT IQBAL868438010465857, 868438010465857A

Is this possible? Thank you

2,172 Views
0 Likes
21 Replies
rbecher
MVP
MVP
‎2014-02-13 08:06 AM

In response to

Good luck..

Astrato.io Head of R&D
174 Views
0 Likes
Not applicable
‎2014-02-13 08:08 AM
Author

In response to rbecher

Thank you

174 Views
0 Likes