topic Re: How to do Inner join two tables in inline data in QlikView

How to do Inner join two tables in inline data

Anonymous — Tue, 14 Aug 2018 05:02:02 GMT

Hello Experts,

Iam taking two different inline data tables and when Iam using inner join the two tables they dont show any records.My data is below type.

TABLE1:

LOAD * INLINE [

A, B, C, D, E, F, G

1, 7, 13, 19, 25, 31, 37

2, 8, 14, 20, 26, 32, 38

3, 9, 15, 21, 27, 33, 39

4, 10, 16, 22, 28, 34, 40

5, 11, 17, 23, 29, 35, 41

6, 12, 18, 24, 30, 36, 42

];

inner join

TABLE2:

LOAD * INLINE [

A, B, C, D, E, F, H

45, 51, 57, 63, 69, 75, 81

46, 52, 58, 64, 70, 76, 82

47, 53, 59, 65, 71, 77, 83

48, 54, 60, 66, 72, 78, 84

49, 55, 61, 67, 73, 79, 85

50, 56, 62, 68, 74, 80, 86

];

please give a solution.

Thanks in advance.

shraddha_g — Tue, 14 Aug 2018 05:27:58 GMT

Inner join will give records existing in both tables.

You don't have any similar records in your data set

arvind1494 — Tue, 14 Aug 2018 05:44:51 GMT

Use of inner join is to get only matching records from both the tables

looking at your dataset their is no matachable records

you need to make concatenate here

BalaBhaskar_Qlik — Tue, 14 Aug 2018 10:35:14 GMT

Refer these, you'll get the idea on results variance by different functions.