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 Bucharest on Sept 18th 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: 
User5878
Contributor
Contributor
‎2021-07-28 03:54 PM

Combine multiple date columns into a single column

I have an excel sheet with the following layout. I'm trying to figure out a way to group the date columns into a single column. I know qlik reads excel file from top to bottom. Is there a way to maybe read this data set horizontally so that the dates are in a single column?

 2020_072020_082020_092020_102020_112020_122021_012021_022021_032021_042021_052021_06
A      12         13       9    5        10        4        3                 -                   -                   -                   -                   -  
B      12                  -                  -      5        8        68        1        5        7        8                 -                   -  
C      11                  -                  -                  -                   -                   -          3        4        2        8        6          8
836 Views
0 Likes
1 Reply