Sharepoint tool brings nulls in as nan

[squelchie]

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

[IraWatt · Accepted solution]

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 · Accepted solution]

Hey @squelchie 

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

Or

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.