Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
temp:
noconcatenate
load * resident yourTAble
where Name <> 'A';
drop yourTable;
concatenate (temp)
load 'A' as Name, 54 as Marks
autogenerate 1;
Hi Nitish
you could try the below
[MAPPING]:
MAPPING LOAD * inline [
Old ,New
44, 54
Map [Marks] using MAPPING;
Regards,
Ridhaa
Hi Nitish
you could try the below
[MAPPING]:
MAPPING LOAD * inline [
Old ,New
44, 54];
Map [Marks] using MAPPING;
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;