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

[carlpaul153]

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?

[mahoneypat · Accepted solution]

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]

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