Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dears,
How are you?
I've an important question for you guys.
I have two excel spreadsheets.
The Spreadsheet #1 have two collumns: The collumn 1 have the Serial Number and in the collumn 2 there is the Shop Name
The Spreadsheet #2 have two collumns: The collumn 1 have the Shop Name and in the collumn 2 there is the Latitude and Longitude
The problem is that some Shop Name's in the Spreadsheet #1 is not available at the Spreadsheet #2 and will never be, because it's not important for me.
So I would like to show in a chart only the Serial Number and Latitude/Longitude of the Shop Names available at the Spreadsheet #2. Not all the Shop Names.
Follow is on picture about what is happening.
So, to resume, what I need is:
How to show in a chart only the Serial Numbers of the Shop Name's available at the Spreadsheet #2? And not all the Serial Numbers!!!
Bye
Hi Kelly
I am doing good thanks 🙂
For your Q, I am sure there are many ways to do this.
Here is one:
Add a line to your loading scripts that identifies from which Excelsheet the information comes so something like:
Load:
'Sheet2' As SheetID
From ....
This you can use in a calculated dimension like:
If (SheetID ='Sheet2' , Serial Numbers)
I hope this is helpfull
Hi,
Maybe you could use "where exists(ShopnameSpredsheet2,ShopnameSpredsheet1)" when loading spreadsheet #1.
You will have to load spreadsheet #2 before using exists()
Sorry Frank, I didn't understand.
Can you give me an example?
Thanks for your attention and patience
No problems 😃
Table:
Load
ShopName,
Lat,
Long
From Spread2;
left join (Table) load
ShopName,
Serial
From Spread1
Where exists(ShopName,ShopName);