Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Team,
I have 2 tables where table 1 consists of 1000 records and table 2 is dynamic on daily bases it will get updated.
so I have one query that when loading script is it possible to not load table 1 in script and script should directly start loading from 2 and not from 1.
~ Yash Salvi
create variable then try to use the if condition like below:
set var=2;
if var=1 then
TableA:
load * inline [
field
a
b
c
];
else
TableB:
load * inline [
field
d
e
f
];
end if;
Hey Anat,
above solution is fine, but what if data is getting reloaded daily/weekly basis??? how can we automate that?? because loading full script seems to be time consuming.
~ Yash Salvi