topic Re: Sharepoint tool brings nulls in as nan in Alteryx Designer Desktop Discussions

Sharepoint tool brings nulls in as nan

squelchie — Fri, 02 Dec 2022 14:39:29 GMT

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

Re: Sharepoint tool brings nulls in as nan

IraWatt — Fri, 02 Dec 2022 14:45:50 GMT

Hey @squelchie,

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

Re: Sharepoint tool brings nulls in as nan

squelchie — Fri, 02 Dec 2022 14:48:45 GMT

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

Re: Sharepoint tool brings nulls in as nan

IraWatt — Fri, 02 Dec 2022 15:51:56 GMT

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.

Re: Sharepoint tool brings nulls in as nan

willhaye — Tue, 06 Dec 2022 23:53:07 GMT

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

Re: Sharepoint tool brings nulls in as nan

IraWatt — Wed, 07 Dec 2022 08:52:47 GMT

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

Re: Sharepoint tool brings nulls in as nan

squelchie — Wed, 07 Dec 2022 09:18:40 GMT

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

Re: Sharepoint tool brings nulls in as nan

squelchie — Wed, 07 Dec 2022 09:30:23 GMT

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.