Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Load only "some" customers

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

4 Replies
Anonymous
Not applicable
Author

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
Partner - Contributor II
Partner - Contributor II

Hi,

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

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

Not applicable
Author

Sorry Frank, I didn't understand.

Can you give me an example?

Thanks for your attention and patience

frank_carlsson
Partner - Contributor II
Partner - Contributor II

No problems 😃

Table:
Load
ShopName,
Lat,
Long
From Spread2;


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