Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have fields like
43101 | 43132 | 43160 | 43191 |
I have to convert this numbers to 43101 to Jan-2018,43132 to Feb-2018,43160 to Mar-2018,43191 to Apr-2018....
This is my code
CrossTable(MonthSales,Sales,3)
LOAD
MKT,
BRAND,
MICR,
"43101",
"43132",
"43160",
"43191",
"43221",
"43252",
"43282",
"43313",
"43344",
"43374",
"43405",
"43435"
This is my data.I have used cross table function.After loading data it looks Thanks
Hi,
Please use combination of Date and Num# to get expected value in load statement :
LOAD Date(Num#(YOURFIELD),'MMM-YY') as yearmonth
FROM DataSource;
Hi,
Please use combination of Date and Num# to get expected value in load statement :
LOAD Date(Num#(YOURFIELD),'MMM-YY') as yearmonth
FROM DataSource;
Try something like this:
PRE:
CrossTable(MonthSales,Sales,3)
LOAD
MKT,
BRAND,
MICR,
"43101",
"43132",
"43160",
"43191",
"43221",
"43252",
"43282",
"43313",
"43344",
"43374",
"43405",
"43435"
FROM SOURCE;
DATA:
NoConcatenate LOAD
MKT,
BRAND,
MICR,
DATE(MonthSales, 'MMM-YYYY') AS YearMonth,
Sales
RESIDENT PRE;
DROP TABLE PRE;
(Sorry about the bad formatting of the code, I'm typing on my mobile device)
Thanks Sumitha kumari.It is working for me.