Named Range not correctly recognized by input tool

I have a situation where my named range is C9:F427 (headers in C9:F9)

Alteryx is recognizing that my header row is row 9, but it's considering columns A and B as fields and assigned headers F1 and F2 respectively.

I've restarted my PC, deleted and reconfigured the input data tool.

It may be worth mentioning that this behavior started after I tried to save this workflow to the Gallery. Pls help me!

image.png

Input

Accepted answers

ntobon

I found a workaround: Open“Master Data” file, go to sheet 'Elements', enter 0 in cell A9 and save the file. That will solve the problem, you won't see the F1 and F2 columns with Null values.
I will check if you are running into a known defect.

All comments

echuong1

I'd have to take a look at your workflow to figure out what may be causing this, but I figured I'd suggest a few workarounds as well.

Are you on 2020.1? In the updated version, you are now able to specify a range directly in the input data tool.

Alternatively, you can use a select/dynamic select tool to remove the two unwanted fields.

bprackleycpa

Thanks for the workaround suggestions!

I am using 2020.1.

The primary reason for wanting to use a named range is that the range may expand or contract in terms of the number of records and I don't trust users to update this accurately in designer nor via an interface. I think I'll use the select tool in the short run. I've also opened a ticket with Support to dig into why this is happening.

Thanks again

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280