topic Re: how to do partial load at script level in Connectivity & Data Prep

how to do partial load at script level

ysalvi43 — Fri, 03 Mar 2023 10:06:35 GMT

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

Re: how to do partial load at script level

anat — Fri, 03 Mar 2023 14:47:21 GMT

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;

Re: how to do partial load at script level

ysalvi43 — Wed, 08 Mar 2023 05:55:46 GMT

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