Getting fileName from Sharepoint Tool

prakhar021

Hi Folks, 

I have a input as Sharepoint Tool. In that I am selecting a excel file from a folder. I want to fetch the file name of this Excel file. Is is possible in Alteryx ? I couldn't find a generic function for this. However  In Sharepoint tool there is an option "Read only full paths" But that just Gives a file name. I need data and file name both. It would be better if for each records I could get File name as a different column

aatalai

@prakhar021 yes this can be done, you need to select the file and then in the configure file tab of the sharepoint input tool scroll to attach meta data and select "LinkFilename"

And then you will get the file name  (with extension) in a new column. Please let me know how you get on