Thanks! This solves one of many problems I have right now. Also good to know, if you pass a boolean from a notebook you can not use True and False, but 1 and 0. In the Pipeline variables it will be set as true and false then.
Hi @sacnan We produced a video on that! th-cam.com/video/Rmf7-WOcouE/w-d-xo.html We also cover it in this video when we pass the set variable to the second notebook. Hope this helps!
Thank you very much for the response . In my use case the item value of the for each activity has to be sent to an variable declared in the notebook. So setting a base parameter is not an option.
Hi @oneNI83 per Bradley, "I work with a lot of different customers and we've also received questions about this on other videos. The use case would be if you had a value you were retrieving in a notebook and you wanted to utilize it some where else. How would you do this? The answer: you use the exitValue to pass the value out of the notebook. I then passed this to another notebook and wrote it to a table. You could also use this as an expression for a file path, or to use in an if else condition, or to supply a value to a stored procedure that you want to execute a script task against. There are a lot of different use cases for needing to get this data out of a Notebook and then using it in a data pipeline. "
Great video Bradley! Are you coming to the European Fabric Community Conference?
Thanks! This solves one of many problems I have right now. Also good to know, if you pass a boolean from a notebook you can not use True and False, but 1 and 0. In the Pipeline variables it will be set as true and false then.
how to pass the value of a fabric pipeline variable to a variable in Notebook ?
Hi @sacnan We produced a video on that! th-cam.com/video/Rmf7-WOcouE/w-d-xo.html
We also cover it in this video when we pass the set variable to the second notebook. Hope this helps!
Thank you very much for the response .
In my use case the item value of the for each activity has to be sent to an variable declared in the notebook. So setting a base parameter is not an option.
Nice.What are the use cases of this ?
Hi @oneNI83 per Bradley, "I work with a lot of different customers and we've also received questions about this on other videos. The use case would be if you had a value you were retrieving in a notebook and you wanted to utilize it some where else. How would you do this? The answer: you use the exitValue to pass the value out of the notebook. I then passed this to another notebook and wrote it to a table. You could also use this as an expression for a file path, or to use in an if else condition, or to supply a value to a stored procedure that you want to execute a script task against. There are a lot of different use cases for needing to get this data out of a Notebook and then using it in a data pipeline. "