I have created one pivot/Crosstab file in the excel with the below screenshot. when i import the file into the Load editor i'm able to see the below screen.
SourceFile Format:
Load Editor format :
i'm unable to find the functions of converting the ( 41640,41671,.........) values to the above excel MON-YYYY format in my Table.
Where i want to get the below format after loading.
Need some Date conversation functions to work on these kind of conversations.