Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have
Table A
ID |
Table B
ID |
I need to check for IDs in TableA and create a Flag where if ID from Table B is present in Table A, then 'Existing', if not 'New'.
How do I do this?
One solution.
tab1:
Mapping
LOAD *, 'Exisitng' INLINE [
F1
123
456
789
];
tab2:
LOAD *, ApplyMap('tab1',F1,'New') As Flag INLINE [
F1
123
456
789
901
112
113
]
;
One solution.
tab1:
Mapping
LOAD *, 'Exisitng' INLINE [
F1
123
456
789
];
tab2:
LOAD *, ApplyMap('tab1',F1,'New') As Flag INLINE [
F1
123
456
789
901
112
113
]
;