Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 | 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 | 01/09/2018 | |
Voice | Australia | 02/07/2018 | |
Voice | Australia | 03/11/2018 | |
commentary | London | Web | 04/09/2019 |
commentary | London | Web | 05/09/2019 |
commentary | London | Web | 06/11/2019 |
Crosstable(datetype,date,3)
Load Name,Country, Type,date1,date2,date3 from current
Drop field datetype;