New Table from Other Tables

[evansabres]

I am wondering if it is possible to create a table comprised of values from other non-related tables.

I have table A with two fields that I would want, same with Table B, C, D & E, down the line. The fields are non-related but I want to create a summary table.

Is this possible?

[Gysbert_Wassenaar]

Yes, that's possible.

[evansabres]

How is this done in the script?

[Gysbert_Wassenaar]

You load the tables A,B,C,D and E and then create the summary table.

[evansabres]

Have never done this before in a Qlikview environment, what is the structure of the script?

[evansabres]

Here is an example of what I have and my desired result: I desired the same three fields from each table to be stored into a summary table:

Table1:

brandnme,

videonmebb,

videoviewbb

FROM [internal data source]

Table2:

brandNME,

videoNMEra,

videoviewra

FROM [internal data source]

[Gysbert_Wassenaar]

I can't make out what's what you have and what's your desired result table.

[evansabres]

For each table I have listed, I would want the three values I have listed. There are roughly 7-10 tables with similar information. I want to create a singular table that lists these values into one table.

[Gysbert_Wassenaar]

It's still not clear to me. Could you give an example with some data from two tables and the resulting summary table you expect?

[evansabres]

Current tables

Table1:

brandNME, videoNMEbb, videoviewbb

team1,          video title          1,295

team1,          other video title, 1,637

FROM [internal data source]

Table2:

brandNME, videoNMEra, videoviewra

team2,          some title,    2,973

team2,          other title,      3,791

FROM [internal data source]

Desired table

brandNME, videoNME, videview

team1,   video title, 1,295

team1,   other video title, 1,637

team2,    some title, 2,973

team2,     other title, 3,791