topic Re: Help on Partial Load in QlikView

Help on Partial Load

priyarane — Wed, 25 Nov 2020 16:16:04 GMT

Hi Community,

Can some one help one partial for the below example.

Out of thre only one table will effect each run.

Table1:
LOAD * INLINE [
Key1, Value1
abc, 200
def, 234
];

Table2:
LOAD * Inline [
Key1, Value1
D, 100
E, 200
F, 200
];

Table3:
LOAD * INLINE [
Key1, Value1
G, 100
H, 200
I, 100
];

_priya

Re: Help on Partial Load

Anil_Babu_Samineni — Thu, 16 Nov 2017 09:30:22 GMT

May be use NoConcatenate for each to bifurcate in data model.

Re: Help on Partial Load

priyarane — Thu, 16 Nov 2017 09:32:57 GMT

synthetickeys will form

Re: Help on Partial Load

prma7799 — Thu, 16 Nov 2017 09:37:48 GMT

What are you looking for please share expected output...

Re: Help on Partial Load

avinashelite — Thu, 16 Nov 2017 09:40:07 GMT

for the table with gets effected each time add the Ky word Add only e.g. if the table 3 has to get the latest data then

Table1:
LOAD * INLINE [
Key1, Value1
abc, 200
def, 234
];

Table2:
LOAD * Inline [
Key1, Value1
D, 100
E, 200
F, 200
];

Table3:

ADD only
LOAD * INLINE [
Key1, Value1
G, 100
H, 200
I, 100
];

Re: Help on Partial Load

Anil_Babu_Samineni — Thu, 16 Nov 2017 09:40:30 GMT

NoConcatenate Load prefix will concatenate all fields and produce lot Synthetic keys.

You can use a QUALIFY * to fully qualify the field names (but that's similar to RENAME the fields).

Can we know the use case to rid separate the tables.

Another way i come up with using Flag

Load *, 'T1' as Flag From T1;

Load *, 'T2' as Flag From T2;

Load *, 'T3' as Flag From T3;

Re: Help on Partial Load

avinashelite — Thu, 16 Nov 2017 09:42:24 GMT

how is this concept related to Partial reload ??? bit confused what problem we are trying to solve

Re: Help on Partial Load

Anil_Babu_Samineni — Thu, 16 Nov 2017 09:45:28 GMT

Don't confuse, Title may not same as Body message. Here, The concept is related to bifurcate 3 tables even we have same schema from 3 tables. That is what her intend and it prevent to bright the glow of vision.

Re: Help on Partial Load

priyarane — Thu, 16 Nov 2017 09:52:01 GMT

How data will update for our example there are 3 tables

Table1:
LOAD * INLINE [
Key1, Value1
abc, 200
def, 234
];

Table2:
LOAD * Inline [
Key1, Value1
D, 100
E, 200
F, 200
];

Table3:
LOAD * INLINE [
Key1, Value1
G, 100
H, 200
I, 100
];

Now may be possiblity table one only will be update

LOAD * INLINE [

Key1, Value1

zzz, 288

ddde, 782

];

so now only table one update and other two table should be there

Re: Help on Partial Load

avinashelite — Thu, 16 Nov 2017 09:57:24 GMT

You mean the complete data in the table 1 will change or new records will come to table 1 ??

Re: Help on Partial Load

priyarane — Thu, 16 Nov 2017 09:59:12 GMT

new records should flow in Table1 and old data should go awaly like replace

Re: Help on Partial Load

avinashelite — Thu, 16 Nov 2017 10:02:46 GMT

then every time do a fresh/full reload on the table 1.....so that every time it gets the values which are presently in that table ...

Re: Help on Partial Load

priyarane — Thu, 16 Nov 2017 10:07:29 GMT

as of now there more than 10 tables we are loading in the datamodel for one of 10 updation not every thing.

so we thought of do the partial load(encourage any other model as well)

Note: same column names across tables

Re: Help on Partial Load

avinashelite — Thu, 16 Nov 2017 10:28:43 GMT

In that case do a resident load of the master table and delete the content of table 1 each time and freshly load the new data every time . In order to identify the data (since every column is same it get merged into 1 table ) add a source Identifier like

Table1:

LOAD *,

'Table1' as Source;
LOAD * INLINE [
Key1, Value1
abc, 200
def, 234
];

Table2:

'Table2' as Source;
LOAD * Inline [
Key1, Value1
D, 100
E, 200
F, 200
];

Table3:

'Table3' as Source;
LOAD * INLINE [
Key1, Value1
G, 100
H, 200
I, 100
];

NoConcatenate

Master:

LOAD *

resident

Source<>'Table1';

Drop table tablename;

Table1:

ADD only

LOAD *,

'Table1' as Source;
LOAD * INLINE [
Key1, Value1
abc, 200
def, 234
];