Load only "some" customers

[#1]

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

[Anonymous]

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

[frank_carlsson]

Hi,

Maybe you could use "where exists(ShopnameSpredsheet2,ShopnameSpredsheet1)" when loading spreadsheet #1.

You will have to load spreadsheet #2 before using exists()

[#4]

Sorry Frank, I didn't understand.

Can you give me an example?

Thanks for your attention and patience

[frank_carlsson]

No problems 😃

Table:
Load
ShopName,
Lat,
Long
From Spread2;

left join (Table) load
ShopName,
Serial
From Spread1
Where exists(ShopName,ShopName);