topic Re: New Table from Other Tables in QlikView

New Table from Other Tables

evansabres — Sun, 03 Jun 2018 04:11:43 GMT

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?

Re: New Table from Other Tables

Gysbert_Wassenaar — Sun, 03 Jun 2018 07:41:13 GMT

Yes, that's possible.

Re: New Table from Other Tables

evansabres — Sun, 03 Jun 2018 15:30:06 GMT

How is this done in the script?

Re: New Table from Other Tables

Gysbert_Wassenaar — Sun, 03 Jun 2018 15:54:07 GMT

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

Re: New Table from Other Tables

evansabres — Sun, 03 Jun 2018 16:07:21 GMT

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

Re: New Table from Other Tables

evansabres — Sun, 03 Jun 2018 16:23:40 GMT

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]

Re: New Table from Other Tables

Gysbert_Wassenaar — Mon, 04 Jun 2018 06:50:34 GMT

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

Re: New Table from Other Tables

evansabres — Mon, 04 Jun 2018 12:22:33 GMT

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.

Re: New Table from Other Tables

Gysbert_Wassenaar — Mon, 04 Jun 2018 13:01:39 GMT

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?

Re: New Table from Other Tables

evansabres — Mon, 04 Jun 2018 13:08:07 GMT

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

Re: New Table from Other Tables

Gysbert_Wassenaar — Mon, 04 Jun 2018 13:22:53 GMT

Ah, you want to concatenate the tables.

Summary:

LOAD

brandNME,

videoNMEBB as videoNME,

videoviewbb as videview

RESIDENT

Table1;

CONCATENATE (Summary)

LOAD

brandNME,

videoNMEra as videoNME,

videoviewra as videview

RESIDENT

Table2;