Data showing null from Input tool

I have several columns of data that are not being pulled in correctly in Designer. The columns are text for the most part, but it is not consistent text. For example, I have "DNS", "WD:A01", etc. so there's a mix of letters, numbers and punctuation. The Input tool is just not reading it and all the columns are pulling in as Null. I'm using an XLSX Excel file as my input file format.

Input

Accepted answers

All comments

MelGibson

Can you please provide an input file to review. From what I am understanding you are using an input tool set to xlsx and not all rows are pulling in when you are checking the output of the input tool. Also do you have this checked in your input file tool "First Row Contains Data"

cflem123

Attached is a very simplified version as the actual file contains sensitive data. The rows/columns are pulling in but the data is showing as Null straight from the Input tool so I don't have a chance to manipulate it. And yes, it's set to first row contains data.

Alteryx example.xlsx

nagakavyasri

@cflem123 The above attached input is read properly by Input tool.

Screenshot 2024-11-21 141622.png

If you want WD1,DNS as columns, select Start Import on line 2

Screenshot 2024-11-21 141836.png

MelGibson

@nagakavyasri is correct. I could not get the results you were talking about. When I ran this input all fields showed up as expected. The null field is numeric where the other ones are text, but you can fix that with a select tool right after the input. format issue.png

cflem123

None of the above responses have provided a solution that addresses my issue

MelGibson

Can you share a screenshot like I have, so I can see what you are seeing. When I take your file and drop it into a workflow and run it this is what I am seeing. What I am reading is that all your data is showing null. example file.png

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703