Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Use Concatenate keyword or just put same fields names of both tabel it will auto concatenate.
Hi,
Please find attached the Solution Qvw.
if you have found this helpful mark helpful or Correct.
Regards,
Bhasker Kumar
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