We are trying to Pass parameter to python Script

SushilSingh10 — Mon, 05 Feb 2024 06:53:42 GMT

We have created two parameter named as storeval and itemval. we want to to pass these two parameter to our python Script code but we are not getting the table output from our Python Script please check below Snap

Re: We are trying to Pass parameter to python Script

tharunkumarRTK — Mon, 05 Feb 2024 10:49:32 GMT

Hi Sushil,

There might be many ways of solving this requirement. Here is my solution

Financials is the name of the query and paramSegment is the parameter name.

Pass the data as well as the parmeter values as input to the Python.Execute function and then you will be able to access them, I am attaching the code for your reference

let Source = Excel.Workbook( File.Contents( <Path> ), null, true ), financials_Table = Source{[Item = "financials", Kind = "Table"]}[Data], #"Changed Type" = Table.TransformColumnTypes( financials_Table, { {"Segment", type text}, {"Country", type text}, {"Product", type text}, {"Discount Band", type text}, {"Units Sold", type number}, {"Manufacturing Price", Int64.Type}, {"Sale Price", Int64.Type}, {"Gross Sales", type number}, {"Discounts", type number}, {" Sales", type number}, {"COGS", type number}, {"Profit", type number}, {"Date", type date}, {"Month Number", Int64.Type}, {"Month Name", type text}, {"Year", Int64.Type} } ), GatherParameters = Table.ExpandRecordColumn( Table.FromList( {[Parameter = "Segment", Value = paramSegment]}, Splitter.SplitByNothing(), null, null, ExtraValues.Error ), "Column1", {"Parameter", "Value"} ), PrepareInputforPY = Table.ExpandRecordColumn( Table.FromList({[Data = #"Changed Type", Params = GatherParameters]}, Splitter.SplitByNothing()), "Column1", {"Data", "Params"} ), #"Run Python script" = Python.Execute( "# 'dataset' holds the input data for this script#(lf)# dataset.drop(dataset[dataset['Segment'] == 'Government'].index, inplace=True)#(lf)segment = Params[Params['Parameter'] == 'Segment']['Value'][0]#(lf)dataset.drop(dataset[dataset['Segment'] != segment].index, inplace=True)#(lf)#(lf)", [dataset = PrepareInputforPY[Data]{0}, Params = PrepareInputforPY[Params]{0}] ), dataset = #"Run Python script"{[Name = "dataset"]}[Value] in dataset

Hope this answers your question. If yes then please accept my solution.

Thanks

Tharun

topic We are trying to Pass parameter to python Script in Developer

We are trying to Pass parameter to python Script

Re: We are trying to Pass parameter to python Script