GeoAnalytics tutorial get error msg

[paulyeo11]

Hi All

Qlik Geocoding - Street Addresses and Qlik GeoAnalytics

When i run the above link QVF , i get below error. below of below path issue :-

FROM [Lib://AttachedFiles/video_game_stores.xlsx]

May i know how to set the above path or where i should place the excel file at which directory folder ?

[Quy_Nguyen · Accepted solution]

Your should replace [lib://video_game_stores.xlsx] by [lib://lib/video_game_stores.xlsx]

[paulyeo11]

Hi Quy

You are correct , now working fine.

May I know why I need to add lib ?

Paul Yeo Poh Sai

Director

TDS Technology (S) P/L

HP +6593261804 Whatsapp

HP +6280883521036 INDO

[Quy_Nguyen]

Hi Yeo,

Because you created a connection named lib with the path to your excel file.

If your connection name is MyData , the string will be [lib://MyData/video_game_stores.xlsx]

[paulyeo11]

Hi Quy

Now i understand where i go wrong.

Meaning there are 2 lib , first lib is a must . it is a default for write this script.

Paul Yeo