Sharepoint tool brings nulls in as nan

Hi, please help!

I'm using the SharePoint input tool to pull in from an Excel table.

All the empty values in my table are being pulled in as 'nan'. If I pull the same table in with a regular input tool they are nulls which is what I'd like to happen.

Please can somebody advise how I can pull in empty values as null or at least how I can bulk change all values from nan to null after importing them?

Many thanks in advance

Sharepoint

Accepted answers

IraWatt

Hey @squelchie,

This is a bug with the SharePoint 2.2 tool, if you downgrade to 2.1 this should fix the issue.

IraWatt

Hey @squelchie

You can set the version by dragging on a tool and select the version by right clicking the tool:

You can delete the SharePoint tool here:

C:\Users\<Your User>\AppData\Roaming\Alteryx\Tools

Then install the 2.1 SharePoint tool.

All comments

IraWatt

Hey @squelchie,

This is a bug with the SharePoint 2.2 tool, if you downgrade to 2.1 this should fix the issue.

squelchie

Thanks @IraWatt . How do I go about downgrading please?

IraWatt

Hey @squelchie

You can set the version by dragging on a tool and select the version by right clicking the tool:

You can delete the SharePoint tool here:

C:\Users\<Your User>\AppData\Roaming\Alteryx\Tools

Then install the 2.1 SharePoint tool.

willhaye

Very helpful @IraWatt I spent 15 mins looking for "nan" in my spreadsheet. was about to lose my **bleep**. **bleep** loss avoided.

IraWatt

@willhaye 🤣🤣 I reacted the same when I saw the "nans"

squelchie

@IraWatt thanks for your help. I've downgraded now and all works well.

squelchie

If anybody has trouble finding where to download the previous tool it's on this page

Sharepoint Tools - Alteryx Community

You have to click on the 'read more' link under the description heading to find it, which isn't obvious at first.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703