topic Multiply two tables in App Development

Multiply two tables

Tue, 08 Dec 2015 08:48:31 GMT

Hi all,

I guess my problem is simply if you know how to do it... I'm trying to multiply two tables in a load script e.g. if in one table I have orders and in another table I have statuses I expect to receive for an order depending on the order type.

Example:

table order:

OrderID OrderType

1 A

2 B

table status_expected:

OrderType Status

A 100

A 200

A 300

B 800

B 900

expected output:

OrderId OrderType Status

1	A	100
1	A	200
1	A	300
2	B	800
2	B	900

Thanks for your help,

Jens

Re: Multiply two tables

maxgro — Tue, 08 Dec 2015 15:15:06 GMT

If you just want 1 table use this script (with a join)

[table order]:

load * inline [

OrderID OrderType

1 A

2 B

] (delimiter is spaces);

left join ([table order])

//[table status_expected]:

load * inline [

OrderType Status

A 100

A 200

A 300

B 800

B 900

] (delimiter is spaces);

You can probably get the same result without joining the 2 tables (ie no changes to your script): Qlikview will associate the 2 tables.

Re: Multiply two tables

Tue, 08 Dec 2015 15:25:31 GMT

Thanks, maxgro.

Your first proposal does exactly what I need.