Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i have one data file, which contains Project Number, Project Name, November, December, January as fields. Here November and December belongs to 2013 year and January belongs to 2014. In future they may add data for February, March...
My requirement is i have to change November as Nov, December as Dec, January as Jan...... and i want add year as Nov-13, Dec-13, Jan-14, Feb-14...... But i don't have Year field in my datasheet
I tried with "left(Month,3)&'-'&right(if(left(Month,3) = 'Dec' or 'Nov' or left(Month,3) = 'Nov', Year(Today()), if(left(Month,3) = 'Jan',Year(Today())+1)),2) as Month". But it is not correct way because it works for 3 months.
Please anybody can take a look into this requirement and give me suggestion.
i attached sample QVW and Data file also
Thanks,
M V
Hi Guys,
Any Suggestions ?
Thanks,
M V
hi,
I don't think so this can be done dynamically. but one thing tell me why you are not changing your column name in excel or at the time of load. Because i think you can only change field name dynamically using variables.
Assign any value in a variable and give alias name as like in load script:
Let varDate = 'Nov-13';
Load
FieldName AS $(varDate)]
Resident tableName;
Regards,
Ashutosh
Hi Reddy,
Not sure how sustainable the model could be without an Year field but if your data set will be limited from Nov -13 to Oct - 14, then I think you could probably have an inline table and put this info.
Table:
LOAD * INLINE [
Month, MonthName
November, Nov - 13
December, Dec - 13
January, Jan - 13
..................
..................
October, Oct - 13
];
But if you have further data, wonder how would you identify between Dec - 2013 and Dec - 2014
Regards,
Sree