Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
ashokraju
Contributor II
Contributor II

Inline

Hi,

If we create inline load then what is the relation between inline table with  existing datamodel.

7 Replies
Chanty4u
MVP
MVP

you can create a key field with the main table

Anil_Babu_Samineni

For your question - There is no relation between data model and Island table because these are simple inline tables only. And, If you want to make RDBMS you could use Generation seq key as you need ??

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
ashokraju
Contributor II
Contributor II
Author

Hi..

for performance wise inline tables are good or bad..

Some body said inline load create cross join with our datamodel..so it impacts performance..is it correct..

zhadrakas
Specialist II
Specialist II

you can see that in your Data-Model.

It Could be any relation.

Sample for 1:1

INLINE:
LOAD * INLINE [
Week
21
22
23
]
;

DATAMODEL:
LOAD * INLINE [
Week, Sales
21, 100
22, 200
23, 250
]
;

Perfect Key says every record has one unique match. So 1:1 relation

Sample for 1:n

INLINE:
LOAD * INLINE [
Week
21
22
23
]
;

DATAMODEL:
LOAD * INLINE [
Week, Sales
21, 200
21, 300
22, 223
22, 332
23, 332
23, 999
]
;

Now it is not a perfect key. Only key. There you can see that this is a 1:n relation.

Sample for m:n

INLINE:
LOAD * INLINE [
Week, Test, Sales
21, A, 200
21, B, 200
22, C, 200
22, E, 200
23, A, 200
23, B, 200
]
;

DATAMODEL:
LOAD * INLINE [
Week, Sales
21, 200
21, 300
22, 223
22, 332
23, 332
23, 999
]
;

Now there is an Synthetic Key generated that got rid of the m:n relation.

Hope this helps

Regards

tim

Kushal_Chawda

If you have created inline table and linked with one of the table in data model, then relationship is associative. If you have created inline table which is not connected to any other table in your data model then there is no relationship between your data model and inline table.In this case, these inline table is called as "Data Island"

Kushal_Chawda

To answer your question refer to below link

https://qlikviewcookbook.com/category/performance/

ashokraju
Contributor II
Contributor II
Author

thanku