Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
as off my knowledge nline function is used to create a table where we dont have the database ?and is there any other feature for this
THANKS IN ADVANCE
MapDayOfWeek:
Mapping LOAD * INLINE [
Day, Day of Week
MO, 1
TU, 2
WE, 3
TH, 4
FR, 5
SA, 5
SU, 5
];
LOAD
[Date YYYYMMDD] as FiscalDate1,
applymap('MapDOW', QVDOW) as NumberDayOfWeek
FROM [$(ASIQVDFolder)QVCLDRF.QVD] (qvd)
Hey Manoj,
Mostly using inline tables for mapping/joining with other tables is not advised for cases where the data might change over time as you have to go and manually change the data.
Thanks
AJ