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: 
jtandersen
Contributor II
Contributor II

Build a STOCKS database

Hi 

 

Closing this

 

 

Labels (1)
  • Other

4 Replies
Frank_Hartmann
Master II
Master II

Python is your friend. See attached files as a starting point. I created 3 Python Scripts, for each location one which are called at the beginning of the script (Please adapt the path according your environment). These scripts are extracting the data to the corresponding csv file and afterwards the csv files can be loaded in QV script.

Further details and requirements are here:

https://community.qlik.com/t5/Qlik-Sense-App-Development/How-to-load-local-JSON-file-into-Qlik-Sense...

hope this helps

jtandersen
Contributor II
Contributor II
Author

Hi Frank

Thank you very much, very kind of you

I will test this and give you feedback

Kind regards

John

jtandersen
Contributor II
Contributor II
Author

Hi Frank

Thanks for the script

I have a questions

How can I combine my Excelsheet with all my stocks.
My Excelsheet could look like this

TICKER_SYMBOL, STOCK_NAME

 

Thanks

Regards

John

jtandersen
Contributor II
Contributor II
Author

Hi  Frank

Hope you are well

can you (or anyone else) tell me how I can combine an  Excelsheet with all my stocks and then import data into Qlik for all of them?

Thank you

Take care