topic Re: resident help in QlikView

resident help

Fri, 16 May 2014 05:24:31 GMT

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

Re: resident help

anbu1984 — Fri, 16 May 2014 05:27:34 GMT

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;

Re: resident help

sunilkumarqv — Fri, 16 May 2014 08:09:48 GMT

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;

Re: resident help

jagan — Fri, 16 May 2014 08:30:59 GMT

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.

Re: resident help

Fri, 16 May 2014 10:22:48 GMT

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;