topic Re: Data loading issues from Data model in QlikView

Data loading issues from Data model

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

Hi ,

I tired to load below data into my data model and it is loaded successfully, but when I tired to load it using binary load Was not able to fetch the completed association between the tables.

Table A:

Load Country,

State,

Division,

Revenue,

Profits

From table A;

Concatinate(Table A)

Table B:

Load

Rowno() as% table,

Country,

State,

Division,

Spends

From table B;

Join(Table c)

Table C

Load

Rowno() as% table1,

Country,

Sales

From Table c;

I used link table to relate all three tables.It loaded and association is perfect

but after loading using binary load into my application,the third table missing its association .sometimes after reload few countries getting associated.

Could someone help me how to solve this issue.

Re: Data loading issues from Data model

felipedl — Thu, 19 Oct 2017 12:48:57 GMT

Hi Vijaya,

I've done a sample test with the following:

[Table A]:

Load * Inline

[

Country,State,Division,Revenue,Profits

a,a1,a11,1,1

a,a2,a11,43,2

a,a1,a12,4,56

a,a1,a15,1,1

b,b2,a1,1,1

];

NoConcatenate

[Table B]:

Load * Inline

[

Country,State,Division,Spends

c,c1,c11,1

d,d2,d11,43

e,e1,e12,4

f,f1,f15,1

g,g2,g1,1

];

NoConcatenate

[Table C]:

Load * Inline

[

Country,State,Division,Sales

i,i1,a11,1

i,i2,a11,43

j,j1,a12,4

j,j1,a15,1

k,k2,a1,1

];

NoConcatenate

LinkTable:

Load

RowNo() as %tableA

// Country,

// State,

// Division,

// Revenue,

// Profits

Resident [Table A];

Concatenate(LinkTable)

Load

RowNo() as %tableB

// Country,

// State,

// Division,

// Spends

Resident [Table B];

Join(LinkTable)

Load

RowNo() as %tableA,

RowNo() as %tableC

// Country,

// Sales

Resident [Table C];

Qualify *;

UNQUALIFY %tableA;

DataTableA:

Load

RowNo() as %tableA,

Resident [Table A];

UNQUALIFY %tableB;

DataTableB:

Load

RowNo() as %tableB,

Resident [Table B];

UNQUALIFY %tableC;

DataTableC:

Load

RowNo() as %tableC,

Resident [Table C];

drop tables [Table A],[Table B],[Table C];

That gives me the following data model

And the binary load gives the complete data model.

What I believe its happening is that the tables are being automatically concatenated, due to having the same field names.

Felipe.

Re: Data loading issues from Data model

kvr9 — Mon, 23 Oct 2017 10:45:55 GMT

Hi Feilp,

Thank you,

it worked partially for me,all columns are related except one column from 3rd table after Binary load.

Since the data is confidentially I cant share the snapshot of it.

Request you to help in resolving the issue

Re: Data loading issues from Data model

felipedl — Mon, 23 Oct 2017 11:30:05 GMT

Hi Vijaya,

can you share a snapshot of the Data Model (CTRL+T in View) with the fields that are being connected?

Filter the other ones in paint or so, with a figure on top, just so I can see whats happening on the binary load.

Felipe.

Re: Data loading issues from Data model

kvr9 — Wed, 25 Oct 2017 17:01:11 GMT

Hi Feilp,

Apologies for delay in response.

The issue is D_count table is not associated and it is created by concatenating in transform layer .Should I use join in place of concatenate in transform layer?

Also can you please advise me which is preferable to join the tables Join/Concatenate my data contain same column names only one fact need to link with 1^st table

Re: Data loading issues from Data model

felipedl — Wed, 25 Oct 2017 17:41:47 GMT

Hi VIjaya,

If the data makes sense the way your looking at it, just stay with it.

Otherwise, if you only have, let's say only %BaseNo and D_Count are used in the concatenation, use a separate table for it.

Hope it helps, i didnt understand fully what you meant on your post to be honest.

Felipe.