Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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