Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kvr9
Creator
Creator

Data loading issues from Data model

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.

5 Replies
felipedl
Partner - Specialist III
Partner - Specialist III

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

Sample.png

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.

kvr9
Creator
Creator
Author

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

felipedl
Partner - Specialist III
Partner - Specialist III

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.

kvr9
Creator
Creator
Author

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 1st table

test.PNG

felipedl
Partner - Specialist III
Partner - Specialist III

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.