Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
User5878
Contributor
Contributor

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
1 Reply