Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

resident help

hieee

appp:

LOAD * INLINE [

    eid, cid, name1, salay1

    1, 555, aa, 64754

    2, 666, ss, 4553

    3, 856, uu, 45

    4, 559, tt, 56

    5, 425, oo, 878

    6, 578, jj, 369

];

this is my script and i want to load any two fields from above inline table using resident load. Can i do this

help me

4 Replies
anbu1984
Master III
Master III

Tab:

LOAD * INLINE [

    eid, cid, name1, salay1

    1, 555, aa, 64754

    2, 666, ss, 4553

    3, 856, uu, 45

    4, 559, tt, 56

    5, 425, oo, 878

    6, 578, jj, 369

];

Noconcatenate

Tab1:

Load eid,cid Resident Tab;

sunilkumarqv
Specialist II
Specialist II

appp:

LOAD * INLINE [

    eid, cid, name1, salay1

    1, 555, aa, 64754

    2, 666, ss, 4553

    3, 856, uu, 45

    4, 559, tt, 56

    5, 425, oo, 878

    6, 578, jj, 369

];

Load eid,cid resident appp;

jagan
Luminary Alumni
Luminary Alumni

Hi Akash,

Instead of using * in LOAD statement you can specify columns

appp:

LOAD *

INLINE [

    eid, cid, name1, salay1

    1, 555, aa, 64754

    2, 666, ss, 4553

    3, 856, uu, 45

    4, 559, tt, 56

    5, 425, oo, 878

    6, 578, jj, 369

];

Test:

LOAD

eid, cid

Resident appp;




Or you can once again reload from inline like this

appp:

LOAD eid,

cid

INLINE [

    eid, cid, name1, salay1

    1, 555, aa, 64754

    2, 666, ss, 4553

    3, 856, uu, 45

    4, 559, tt, 56

    5, 425, oo, 878

    6, 578, jj, 369

];

Hope this helps you.

Regards,

Jagan.

Not applicable
Author

inline_tab:

LOAD * INLINE [

    eid, cid, name1, salay1

    1, 555, aa, 64754

    2, 666, ss, 4553

    3, 856, uu, 45

    4, 559, tt, 56

    5, 425, oo, 878

    6, 578, jj, 369

];

res_tab:

LOAD eid as eid1,cid as cid1

RESIDENT inline_tab;