How to do Inner join two tables in inline data

[Anonymous]

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 · Accepted solution]

Inner join will give records existing in both tables.

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

[arvind1494]

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

[balabhaskarqlik]

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

https://www.tutorialspoint.com/qlikview/qlikview_joins.htm

https://community.qlik.com/thread/39177