Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to map the table by using inline function?

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

2 Replies
Anonymous
Not applicable
Author

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)

Not applicable
Author

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

AJ