Forum Discussion

carlpaul153's avatar
carlpaul153
Helper I
5 years ago
Solved

Is it possible to pass a parameter to a python script?

I have a parameter called "File" and the follow Python script:   # 'dataset' holds the input data for this script import pandas data = pandas.DataFrame(dataset) data.to_csv('C:/Users/MyName/Deskto...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    I assume you are doing this as part of your query (instead of through a Python visual, in which your parameter wouldn't get passed).  Does it work with you hard code in a file name?  If that is working, I would edit the M code in the Advanced Editor instead of in the pop-up window.  There you should be able to replace the hard-coded filename with "&File&"  (I assume the whole Python code is surrounded in double quotes in Advanced Editor and this will break it apart and insert in your paramter value.

     

    Regards,

    Pat

     

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

I assume you are doing this as part of your query (instead of through a Python visual, in which your parameter wouldn't get passed).  Does it work with you hard code in a file name?  If that is working, I would edit the M code in the Advanced Editor instead of in the pop-up window.  There you should be able to replace the hard-coded filename with "&File&"  (I assume the whole Python code is surrounded in double quotes in Advanced Editor and this will break it apart and insert in your paramter value.

 

Regards,

Pat

 

  • carlpaul153's avatar
    carlpaul153
    Helper I
    5 years ago

    You are completely right mahoneypat ! thank you very much!!!