topic Re: How to combine data from 2 tables without Sync key in QlikView

How to combine data from 2 tables without Sync key

savithri_n_s — Wed, 25 Nov 2020 16:16:04 GMT

Hi team,

I have 2 tables Final spend and FY18 YTD Feb

Shown the below data from Final spend table in dashboard1

And reminding rows are from FY18 YTD feb.How can i show both data in single table without using sync key

bhaskar_sm — Sun, 06 May 2018 15:29:51 GMT

Hi,

i cant able to open attached Qvw. can you please provide sample data and exactly what you are trying to achieve.

Regards,

Bhasker Kumar

deepak_gupta — Sun, 06 May 2018 16:47:38 GMT

Use Concatenate keyword or just put same fields names of both tabel it will auto concatenate.

bhaskar_sm — Sun, 06 May 2018 16:55:18 GMT

Hi,

Please find attached the Solution Qvw.

if you have found this helpful mark helpful or Correct.

Regards,

Bhasker Kumar

Anonymous — Mon, 07 May 2018 00:48:16 GMT

if the data is not really related you can rename the same fields of the second load statement

that causes the $syn keys

GU/Country/Current Monthyear/OG/OU/GP/ServrGrp

or you can concatenate them into single key

load

//concatenate(GU/Country/Current Monthyear/OG/OU/GP/ServrGrp) as Key

GU & '/' & Country & '/' & [Current Month/Year] & '/' & OG & '/' & OU & '/' & GP & '/' & ServGrp AS Key

FROM [FY18 YTD Feb.xlsx] (ooxml, embedded labels, table is Sheet1);

Load

//concatenate(GU/Country/Current Monthyear/OG/OU/GP/ServrGrp) as Key

GU & '/' & Country & '/' & [Current Month/Year] & '/' & OG & '/' & OU & '/' & GP & '/' & ServGrp AS Key

FROM [Final spend.xlsx] (ooxml, embedded labels, table is Sheet1);

possible syn key solution

1.An ANSI JOIN – Join Table by common fields
2.A Concatenated Key - Create a key on your own by concatenating the common fields
3.Concatenated Tables- Combine (concatenate) the tables so you have all the possible values