Reading sharepoint data into python tool

[nidahahmad]

Hi,

have a data set which has been pulled from sharepoint, the data needs to be converted into data frame for python tool in alteryx.

as i have forecating model to be build in python, but i can't figure out how to read the data in python tool after pulling it from sharepoint server

[danilang]

Hi @nidahahmad 

If you already have the data in Alteryx, just connect the last tool in the workflow that reads the input to the input on the Python tool.  Within the Python tool use a line similar to df = Alteryx.read("#1").  This will read the data from the 1st data input as a dataframe

Dan

[nidahahmad]

if it just reads the 1st data input how would it read 5000 data points then?

[salbol1]

He means since you can read in multiple streams into the python tool, the stream representing your data can be read in as #1 alteryx.read("#1"). You can, of course, name your connections in to be more descriptive of the data so it makes more sense in your scripting. Then it would be Alteryx.read("Excel_Data"), etc. - whatever you name the streams.