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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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;