Qlik Community

Qlik Sense App Development

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

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
ankithreddy
New 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 (2)
1 Reply
asinha1991
Contributor III

Re: Qlik Sense Data - Columns to Rows

Crosstable(datetype,date,3)

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

 

Drop field datetype;