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...
  • mahoneypat's avatar
    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