How to combine data from 2 tables without Sync key

[savithri_n_s]

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]

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]

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

[bhaskar_sm]

Hi,

Please find attached the Solution Qvw.

if you have found this helpful mark helpful or Correct.

Regards,

Bhasker Kumar

[Anonymous]

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