topic how to map the table by using inline function? in QlikView

how to map the table by using inline function?

Tue, 11 Feb 2014 19:24:26 GMT

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

Re: how to map the table by using inline function?

Anonymous — Tue, 11 Feb 2014 19:29:26 GMT

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)

Re: how to map the table by using inline function?

Tue, 11 Feb 2014 19:31:24 GMT

Hey Manoj,

Creation of Data Islands for creating flags
Mapping Tables

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