Forum Discussion
Helper VNeed to pass multiple values as parameters in notebook by using pyspark
Hi Team,
I have a notebook using pyspark.
there i have written a code that is fetching share market value for every 5 mins. below is my notebook code
In above snap, i have given company name as ABC and i have parameterized that cell and i am getting below results in my lakehouse as table and adding a single row for ABC company for evry 5 mins(i scheduled it for 5 mins)
now my question is i need to get some more companies data like ABC,XYZ,PQR companies data in that same table as rows one after other as rows, it means for every 5 mins 3 rows should add(one row for each company)
I was able to get this using pipeline using config table, but i need to achieve it by using only notebook and giving parameters list in the notebook.
can somebody look into it and do needful.
TIA
Here's a really simple example.
In your parent notebook you would set a dictionary from a list of keys/values, then you would call the child notebook (Notebook 1) in this case by passing in that dictionary as a parameter. You could then do anything you want with the values coming in.
Parent Notebook:
Notebook 1:
Make sure to set the companylist as a parameter
Results:
5 Replies
- 12angrymentiger
Advocate III
Here's a really simple example.
In your parent notebook you would set a dictionary from a list of keys/values, then you would call the child notebook (Notebook 1) in this case by passing in that dictionary as a parameter. You could then do anything you want with the values coming in.
Parent Notebook:
Notebook 1:
Make sure to set the companylist as a parameter
Results:
ajaroraMicrosoft Employee
Did you check this : https://learn.microsoft.com/en-us/fabric/data-factory/notebook-activity ?
Hi sudhav ,
Thanks for using Fabric Community.
Could you please send the screenshot of the notebook code which you are using for loading the data into Lakehouse table?
This would help us in understanding the ask better.Hi sudhav ,
We haven’t heard from you on the last response and was just checking back to see if you could provide the details asked above. Please let us know if you have any further queriesHi sudhav ,
Following up to check whether your issue has been resolved. Please do let us know if you have any further queries.
