create a new table based on two other tables where no values match

[#1]

Hello all,

I am trying to create a new table in my application based on exploding two other tables where no values match.

Here is an example:

TableOne:

A

B

TableTwo:

1

2

3

ResultTable:

A, 1

A, 2

A, 3

B, 1

B, 2

B, 3

Its relatively straightforward with SQL as you can perform an inner join specifying where TableOne.Field1 <> TableTwo.Field1 but I cant work out how to affect the same thing in Qlikview.

As always, any help is enormously appreciated.

Thanks.

[Anonymous · Accepted solution]

I think the solution is fairly simple. Just use a join statement on your second table. Try the following code:

TableOne:
LOAD * INLINE [
 F1
 A
 B
];
TableTwo:
JOIN LOAD * INLINE [
 F2
 1
 2
 3
];

[#3]

Thanks Jack, You're right, it was simple

[eiconsulting]

I think this should do the same as SQL... I did a table showing F1 and F2 and it appears OK

Flavio

[code\]

LOAD * INLINE [
F1
1
2
3
4
5
];

INNER JOIN LOAD * INLINE [
F2
a
b
c
];