3 Replies Latest reply on Jun 26, 2018 8:06 PM by Jon Boschee

Number coming back as NULL

Jon Boschee Jun 26, 2018 6:23 PM

Hi everyone,

I have an excel file with exchange rates that is one of my data sources. For some reason for one of the countries the value comes back as NULL even though it's 1 in the excel file. All the other country come through fine,I've tried some different formats, but no luck.

Anyone run into this before?

Thanks!

1. Re: Number coming back as NULL

Zhouyi Zhang Jun 26, 2018 7:05 PM (in response to Jon Boschee)

Hi, Jon

Can you reproduce this issue with a sample workbook to share?

ZZ
Like Show 0 Likes(0)

Actions
2. Re: Number coming back as NULL

Deepak Rai Jun 26, 2018 7:39 PM (in response to Jon Boschee)
Hi Jon
Do This Thing...
Looks like you have Blanks in first few rows of your excel data, Just Sort data So that First Few Rows are not blank
If the above does not work save file as .csv and bring it as Text file into Tableau
Thanks
Deepak
Like Show 0 Likes(0)

Actions
3. Re: Number coming back as NULL

Jon Boschee Jun 26, 2018 8:06 PM (in response to Deepak Rai)

Saving it as a text file seemed to work. I need to do some QA checks to make but it looks good.

Thanks!
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Number coming back as NULL

1. Re: Number coming back as NULL

2. Re: Number coming back as NULL

3. Re: Number coming back as NULL

Actions

More Like This