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/Desktop/'"&File&"'.csv')

 

I have based my solution on this post, but it doesn't work.

What am I doing wrong? How can I get the script to save the file with the parameter name?

 
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

     

2 Replies

  • 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