...DISTINCT
ID.#KEY
RESIDENT Transaction;
LEFT JOIN (Transaction)
LOAD *,
ID.#KEY AS ID_2.#KEY
RESIDENT temp_ID;
DROP TABLE temp_ID; The result is what I'd expect it to be, there are no d...
Hi Team,
I did Inline load i.e.
Load * INLINE [ Selector,SelectorId Per NSR%,1 Per MT,2 ];
from that Inline load how to do Max(SelectorId) as SelectNum1.
Thanks,
Rajitha
Hello all,
This is the first time I am trying to create a ResidentLoad statement and seeking some help-
Data is coming from 3 different tables. Table -1, Table 2, Table 3
It looks something l...
...62 g, 563 ]; Now I would like to concatenate the two tables, but with the "Where not Exists" clause. Concatenate(test1) Load * Resident test2 Where not Exists(F1); Drop Table t...
