Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Pls advice me Can I edit preloaded inline table & how ?
Thanks in advance.
Neeraj Kumar (NK)
May be like:
InTab:
Load * Inline [
F1
1
2
3
4
5
];
Load F1,
F1*100 As NewF1
Resident InTab Where F1>2 ;
Basic idea is to use RESIDENT and use conditional load (like where clause, or any other expression in the field itself).
Hi
Try like this
Load A as B;
Load * inline
[
A
10
20
];
Preceding load or resident load are the way
You can directly edit in your inline table like below:
LOAD A, B, A*B AS C INLINE [
A, B
1, 3
4, 5
] ;
You can apply any load transformation in INLINE itself.