Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

need help in using inline properly

i have two tables

book
austin
jimmy

geography
austin
jimmy
london
paris
new york
denmark
holland

now austin and jimmy does not actually come under geography but they are there in the table,

london, paris, newyork and denmark come under austin and holland come under jimmy.

now what i want to do is mapping between these two tables so that when i click austin from book table only london paris newyork and denmark should get selected from geography table and when i click jimmy only holland should be selected from geography table.

5 Replies
PrashantSangle

Hi,

Use Inline table to map

BookAuthor:

LOAD * INLINE [

    Book

    Austin

    Jimmy

];

Book_Geography:

LOAD * INLINE [

    Book, Geography

    Austin, london

    Austin, paris

    Austin, newyork

    Austin, denmark

    Jimmy, holland

];

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
its_anandrjs

Try to load your table like this way

Book:

LOAD * INLINE [

    Book

    Austin

    Jimmy

];

Geography:

LOAD If(Match(Geography,'london','paris','newyork','denmark'),'Austin',

          if(Match(Geography,'holland'),'Jimmy')) as Book,Geography;

LOAD * INLINE [

    Geography

    london

    paris

    newyork

    denmark

    holland

    Austin

    Jimmy   

]Where not Match(Geography,'Austin','Jimmy');

Not applicable
Author

can i do it using applymap

maxgro
MVP
MVP

mapbook:

mapping load * inline [

from,to

london, austin

paris, austin

new york, austin

denmark, austin

holland, jimmy

];   

geography:

load geography, ApplyMap('mapbook', geography) as book;

load * inline [

geography

london

paris

new york

denmark

holland

];

its_anandrjs

But you have to hard code the table and do the mapping load for the table Book.

Book:

Mapping LOAD * INLINE [

    Geography,Book

    london,Austin

    paris,Austin

    newyork,Austin

    denmark,Austin

    holland,Jimmy];

Geography:

LOAD Geography,ApplyMap('Book',Geography) as Book;

LOAD * INLINE [

    Geography

    london

    paris

    newyork

    denmark

    holland];