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

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

Tue, 01 Sep 2009 19:07:50 GMT

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:

TableTwo:

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.

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

Anonymous — Tue, 01 Sep 2009 19:24:47 GMT

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
];

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

Tue, 01 Sep 2009 19:31:29 GMT

Thanks Jack, You're right, it was simple

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

eiconsulting — Tue, 01 Sep 2009 20:31:33 GMT

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
];