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...
Hi Experts,
I am seeing difference in row counts when loading data directly from QVD and loading the same data as residentload.
Ex:
Temp_Table:
Load a,b,c from xyz.qvd;
T...
...toreLocation_ID = 49434 AND Qty > 0
GROUP BY Comp_ID;
tProduct:
LOAD
*,
(Minstock + 1) as Test
Resident tProductTemp;
drop Table tProductTemp; If I use only the part above "t...
