How to use inline table?

[#1]

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? 

[ali_hijazi]

temp:

noconcatenate

load * resident yourTAble

where Name <> 'A';

drop yourTable;

concatenate (temp)

load 'A' as Name, 54 as Marks

autogenerate 1;

[rido1421]

Hi Nitish

you could try the below

[MAPPING]:

MAPPING LOAD * inline [

Old ,New

44, 54

Map [Marks] using MAPPING;

Regards,

Ridhaa

[rido1421]

Hi Nitish

you could try the below

[MAPPING]:

MAPPING LOAD * inline [

Old ,New

44, 54];

Map [Marks] using MAPPING;

[its_anandrjs]

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;