Beginner needs assistance with Null in data fields -

[freinerd]

This is my first project and I can not get the excel file to upload correctly as it keeps saying Null in the data fields. I have tried to change #7 in the options window- "Start Data Import on Line". I have tried 2, then 3, and so on up to 10.  I hit refresh, then run. - still "Null".  I then tried the Data Cleansing Tool and that did produce a very limitied amount of data with most of the fields saying Null.   

For step one of the assignment, I have to read in the exdel file, add a record identifier to each row and update the column headers.  I am able to do all of that, but the data fields are saying Null. Please help if you can. 

Thanks you.

[EnglishmaninNY · Accepted solution]

I would do the following:

- adjust the "Start Data Import on Line" in the input tool so that it matches column headers. It looks like you are ~8 rows off. It sounds like you've already played around with this already and maybe you've decided to start earlier so you can pull in the Report data in too and that might make sense but this approach will avoid having to rename as many columns/fields which you've already done. The Dynamic Rename tool might also be helpful and you can easily load the example to figure out how they work.

- Filter tool out all the rows where all fields are null or contain "===="

- Select tool to remove columns/fields with no data

- Cleanse tool should then be able to sort out all the nulls (you might need to send some more snapshots so we can diagnose 

- Auto field tool should change the data types to the correct types too

[freinerd · Accepted solution]

I will try this! Thank you!