topic Re: How to Link 2 Sheets that have the same fields in App Development

How to Link 2 Sheets that have the same fields

aftabn10 — Mon, 20 Dec 2021 21:32:42 GMT

Hi, I am looking for some help with trying to link 2 sheets that have a number of Filters that I have setup but are both sitting in separate tables. The reason this is because I have a number of aggregated columns that are different for the 2 tables and want to keep this separately as I will be building more sheets as I go along.

The filters that are the same within the 2 sheets are the following:

we_date
product
manager
patch

Through the data manager I managed to create an association between the 2 tables for we_date but from reading on this site and other searches on Google I can't make any associations between these tables and this is where I am stuck.

The 2 sheets will now allow me to filter using the we_date, but if I use the filters for product, manager or patch then nothing happens on my 2nd sheet as they are not linked.

Currently in my data load editor I have 2 sections of select queries like the following:

Table1

QUALIFY *;
w:
SELECT
*
FROM
table1
;
UNQUALIFY *;

Table2

QUALIFY *;
w_c:
SELECT
*
FROM
table2
;
UNQUALIFY *;

I would really appreciate if somebody could advise a fix on the issue I am having.

Re: How to Link 2 Sheets that have the same fields

Aditya_Chitale — Thu, 12 Mar 2020 10:53:37 GMT

hi,

you just need to create a key by combining the common fields from both the tables and link the two tables using the key.

eg. w:

we_date & product & manager & patch as link_key;

w_c:

w_c_we_date & w_c_product & w_c_manager & w_c_patch as link_key;

regards,

Aditya Chitale

Re: How to Link 2 Sheets that have the same fields

aftabn10 — Thu, 12 Mar 2020 10:57:20 GMT

Thanks Aditya, do I just add that in each section (data load editor) after the select query?

QUALIFY *;
w:
SELECT
*
FROM
table1
;
UNQUALIFY *;

we_date & product & manager & patch as link_key;

Re: How to Link 2 Sheets that have the same fields

Aditya_Chitale — Thu, 12 Mar 2020 10:59:30 GMT

Hi Aftab,

you need to create the key in both the tables

Regards,
Aditya Chitale

Re: How to Link 2 Sheets that have the same fields

aftabn10 — Thu, 12 Mar 2020 11:39:35 GMT

Thanks Aditya, will work out how to do it as first time I will have used it.

Re: How to Link 2 Sheets that have the same fields

aftabn10 — Fri, 13 Mar 2020 15:17:35 GMT

Aditya, apologies once again for the silly question.

I wrote the load as shown below in the 2 sections but the filters still don't work, feel as though I have missed something out or not doing it right.

QUALIFY *;
w:
SELECT
*
FROM
table1
;
UNQUALIFY *;

LOAD
we_date & product & manager & patch as link_key;

QUALIFY *;
w_c:
SELECT
*
FROM
table2
;
UNQUALIFY *;

LOAD
w_c.we_date & w_c.product & w_c.manager & w_c.patch as link_key;

Re: How to Link 2 Sheets that have the same fields

Aditya_Chitale — Sat, 14 Mar 2020 06:32:38 GMT

Hi Aftab,

Can you please share the data so that we can look into it in detail

Regards,

Aditya Chitale