topic Re: How to use inline table? in QlikView

How to use inline table?

Tue, 15 Jul 2014 06:29:06 GMT

i have a table

Name Marks

A 44

B 35

C 97

D 38

I want to written 54 instead of 44.how i can change it through inline table?

Re: How to use inline table?

ali_hijazi — Tue, 15 Jul 2014 06:31:16 GMT

temp:

noconcatenate

load * resident yourTAble

where Name <> 'A';

drop yourTable;

concatenate (temp)

load 'A' as Name, 54 as Marks

autogenerate 1;

Re: How to use inline table?

rido1421 — Tue, 15 Jul 2014 06:32:57 GMT

Hi Nitish

you could try the below

[MAPPING]:

MAPPING LOAD * inline [

Old ,New

44, 54

Map [Marks] using MAPPING;

Regards,

Ridhaa

Re: How to use inline table?

rido1421 — Tue, 15 Jul 2014 06:35:04 GMT

Hi Nitish

you could try the below

[MAPPING]:

MAPPING LOAD * inline [

Old ,New

44, 54];

Map [Marks] using MAPPING;

Re: How to use inline table?

its_anandrjs — Tue, 15 Jul 2014 06:35:14 GMT

Try to load your table like

Ex:-

Source:

LOAD * INLINE [

Name, Marks

A, 44

B, 35

C, 97

D, 38

];

Inline_Tab:

LOAD * Inline

[

Name, Marks

A,54

];

FinalTable:

NoConcatenate

LOAD

Name,

MaxString(Marks) as Marks

Resident Source

Group By Name;

DROP Table Source;