Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following tables and the respective fields in them
A
ID
CKey
B
CKey
Date
AKey
C
AKey
Appl
I want ID, Date, Appl in a single table. How do I achieve this? Left Join? Or ApplyMap to peek into? Please help and suggest.
For me the best thing would be to use ApplyMap.
A:
MAPPING LOAD
CKey,
ID
from ....
C:
MAPPING LOAD
AKey,
Appl
from ....
B:
LOAD
CKey,
ApplyMap('A', CKey, '--') as ID,
Date
AKey
ApplyMap('C', AKey, '--) as Appl
from ....
The tables with Mapping load are not loading. The load doesn't even go there, to these tables with Mapping Load
When you load a table with MAPPING LOAD, the table is not visualized because it is virtual and only serves to be used in ApllyMap.
In my example, I have not finished writing the LOAD clauses and I have left it with the from ....
Send my some real values and I write the script for these data.
Hi,
this really depends on your data and what you need to achieve. In some cases you could be perfectly OK with Left Join or Outer Join, while in other cases I'd go with what ecolomer suggests.
Juraj