CSV not importing all the data from Sharepoint

Hi,

I am trying to import a CSV file from a Sharepoint site with some data on Dates (file attached).

Sharepoint input tool configuration looks like this:

However, I get the following output which does not make sense. I get only 1 column and that too incorrect.

I am facing similar weird issue with other CSVs I have. And this issue has started happening only in the past few days. Prior to that I have been working with the same files and the same Alteryx tools for the past 2 months and never had any issues with any CSV file.

Please help!

dates.csv

Datasets

Input

Output

Date Time

Time Series

Sharepoint

Accepted answers

sau953

Found the solution !!

As it turns out, even if one installs the latest Sharepoint tool (2.4.0) the older versions of the same tool can still override it.

I uninstalled Alteryx, deleted all the folders related to it including the tools folder which had 4 different versions of the Sharepoint tool and then did a fresh install.

This finally solved all the issues. All files now getting imported perfectly like before.

All comments

FrederikE

Hey @sau953,

Which SharePoint Tool Version are you using? I also had these probs a while back with 2.2.

2.1 worked well - don't know about the newer ones, but downgrading should help.

sau953

I have been using 2.4 (the latest one) since its launch in March and it has been working fine for the past 2 months but suddenly now does not work.

I will try to use 2.1, thanks!

sau953

Unfortunately 2.1 also didn't work.

FrederikE

nvm - stupid comment

sau953

Found the solution !!

As it turns out, even if one installs the latest Sharepoint tool (2.4.0) the older versions of the same tool can still override it.

I uninstalled Alteryx, deleted all the folders related to it including the tools folder which had 4 different versions of the Sharepoint tool and then did a fresh install.

This finally solved all the issues. All files now getting imported perfectly like before.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703