Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikEnth
Contributor II
Contributor II

Qlik Sense Data - Columns to Rows

Hello Experts,

I have a Data in a Excel Sheet Like Below (with 3 Date Columns), i need to convert these 3 Date Columns into three Individual Rows with 1 Single date Column.

I Tried to Implement with cross Table with 1 Column Earlier, Any Thoughts with data Like Below 

 

Current Data:

NameCountryTypeDate1Date2Date3
VoiceAustraliaMail01/09/201802/07/201803/11/2018
 commentaryLondonWeb04/09/201905/09/201906/11/2019

 

Expected Output:

NameCountryTypeDate
VoiceAustraliaMail01/09/2018
VoiceAustraliaMail02/07/2018
VoiceAustraliaMail03/11/2018
 commentaryLondonWeb04/09/2019
 commentaryLondonWeb05/09/2019
 commentaryLondonWeb06/11/2019
Labels (1)
1 Reply
asinha1991
Creator III
Creator III

Crosstable(datetype,date,3)

Load Name,Country, Type,date1,date2,date3 from current

 

Drop field datetype;