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
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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: 
lg92
Contributor II
Contributor II
‎2021-07-14 05:14 AM

Convert row to column

Hi everyone,

I need to convert row to column about this table renaming cluster that repeat 

ID;  DATE;  TIME; CLUSTER
000200380242-0010;   11/11/2019;   07:32:31;   RICE
000200380242-0010;   11/11/2019;   07:35:35;   VIAG
000200380242-0010;   11/11/2019;   07:36:33;   RIRI
000200380242-0010;   11/11/2019;   08:23:32;   RICE
000200380242-0010;   11/11/2019;   12:08:00;   VIAG
000200380242-0010;   11/11/2019;   12:08:08;   POST
000200380242-0010;   11/11/2019;   12:08:14;   INIZ
000200380242-0010;   11/11/2019;   15:08:33;   COMP

 

The output would be this

ID;                                          DATE;               RICE;            VIAG;           RIRI;           RICE 2;          VIAG 2;           POST;          INIZ;     COMP
000200380242-0010;   11/11/2019;   07:32:31;   07:35:35;   07:36:33;   08:23:32;   12:08:00;   12:08:08;   12:08:14;   15:08:33

 

Thank you in adavance 

753 Views
0 Likes
1 Reply
Vasiliy_Beshentsev
Creator III
Creator III
‎2021-07-14 06:05 AM

Take a look at this topic

715 Views