Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thanks
Rams.
Sample file needed and also complete code from cross table load to final resident load.