Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I have few tables and need to fletch some columns only,
Ex:
Tables:
COLLATERAL
CONTRACT_GUARANTEE
ENTITY
FACILITY
And columns are
ex:
From table: COLLATERAL - columns are: Dim1, Dim2, Dim3.
From table: CONTRACT_GUARANTEE- columns are: XDim1, XDim2, XDim3.
Like that.
Generally we can flethc the data then we can remove unwanted data.. but here I am looking for any simple methat or new one by using some functions.
I have multiple tables that is why I am asking.
This is what you need if I understand from you question correct:
Load
Dim1,
Dim2,
Dim3
from COLLATARAL ...... ;
Load
XDim1,
from CONTRACT_GUARANTEE .....;
etc.
I presume you mean fetch instead of fletch. You might want to look up what fletching actually is
The best idea is to specify the columns you do want to extract. That way you don't load unnecessary data in the first place. If you're lazy and don't care about extra network traffic and storage volumes you can load all the data and drop fields afterwards using the DROP FIELD instruction.
so why don't you load only the required columns?
Collateral:
Load Dim1,
Dim2,
Dim3
from Collateral...
Contract_Guarantee:
Load
XDim1,
XDim2,
XDim3
from Contract_Guarantee...
THat what you want?