I loaded my Excel sheet which included a column of years (such as 2015, 2009, 2004, etc.). When my Excel file was loaded into Qlik the dates appear as strings, 42005, 39904, etc. I would like to turn them back into years. I think I need to define that column as yyyy. However, I have not actually used the Data Load Editor before. I just have it do everything automatically. Would I click 'unlock' first?
Below is part of the script in the LOAD section. I want to change [COMPL_PER_BEGIN_YEAR] to show just yyyy. I would like to keep the [COMPL_PER_BEGIN_DATE] as it is, however, which is 1/1/2015, 4/1/2009, etc.
[COMPL_PER_BEGIN_YEAR] AS [COMPL_PER_BEGIN_YEAR],
Date([COMPL_PER_BEGIN_DATE] ) AS [COMPL_PER_BEGIN_DATE]
Your assistance is appreciated. Thank you.
