Importing CSV and seeing a lot of NULLS

[Adam_B]

Hello, I am importing a CSV file and seeing a lot of NULLS in the file.  However, when I open the file in Excel, there is data in the cells, the row count I see in Excel is 1050, Alteryx shows 1053.  Why is that happening?

Thanks,

Adam  

 

 

[Prometheus]

@Adam_B Is it possible that you have some rows hidden in Excel? You'll see all of them in Alteryx.

[Adam_B]

Hi @Prometheus , no, I checked that.  Very odd. 

[apathetichell]

Are you on alteryx 2023.1? 

[Adam_B]

@apathetichell @Prometheus I updated my Alteryx to the most recent version however still having issues.  Nulls being inserted for no reason.   

[Prometheus]

@Adam_B Could you please post your workflow with a sanitized version of your data? That would helpful for us in solving your issue.

[Adam_B]

The issue was resolved, I just used another workflow and imported the same file, it was fine.  Appreciate your willingness to assist. 

Thanks, 
Adam