Accept widget value during runtime from user

[LJ]

list1 = ('alpha', 'beta', 'gamma', 'eta', 'Theta')

list2 = ('alpha', 'beta')

df1 = spark.createDataFrame(list1, 'String').withColumnRenamed('value', 'dataset')

df2 = spark.createDataFrame(list2, 'String').withColumnRenamed('value', 'dataset')

df = df1.exceptAll(df2)

list_of_values = [data[0] for data in df.collect()]

dbutils.widgets.dropdown("dataset", list_of_values[0], list_of_values)

dataset = dbutils.widgets.get("dataset")

print(dataset)

In above code is there a way to get data from user after widget creation?

[Hubert-Dudek · Accepted solution]

Every time the user change selection in the widget, you get that selection—behavior after the dropdown change you can define in widget settings.

[Kaniz]

Hi @Liju Thomas​, We haven’t heard from you since the last response from @Hubert Dudek​ , and I was checking back to see if you have a resolution yet.

If you have any solution, please share it with the community, as it can be helpful to others. Otherwise, we will respond with more details and try to help.

Also, Please don't forget to click on the "Select As Best" button whenever the information provided helps resolve your question.