Inline

[ashokraju]

Hi,

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

[Chanty4u]

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 ??

[ashokraju]

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]

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]

thanku