Qlik Sense Data - Columns to Rows

QlikEnth — Sat, 16 Nov 2024 20:04:07 GMT

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:

Name	Country	Type	Date1	Date2	Date3
Voice	Australia	Mail	01/09/2018	02/07/2018	03/11/2018
commentary	London	Web	04/09/2019	05/09/2019	06/11/2019

Expected Output:

Name	Country	Type	Date
Voice	Australia	Mail	01/09/2018
Voice	Australia	Mail	02/07/2018
Voice	Australia	Mail	03/11/2018
commentary	London	Web	04/09/2019
commentary	London	Web	05/09/2019
commentary	London	Web	06/11/2019

Re: Qlik Sense Data - Columns to Rows

asinha1991 — Tue, 17 Sep 2019 21:06:05 GMT

Crosstable(datetype,date,3)

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

Drop field datetype;

topic Re: Qlik Sense Data - Columns to Rows in App Development

Qlik Sense Data - Columns to Rows

Re: Qlik Sense Data - Columns to Rows