my input file's field name changes case, how to make input tool dynamic to identify it in

[hf14]

My input file's columns sometimes come in uppercase with no whitespace and sometimes it come in lowercase with whitespaces.

If first time i load the file and it comes in uppercase columns, in input configuration I check those columns

then second time the file comes in lowercase with whitespaces, the same column names (but in uppercase) gets highlighted as 'missing', then again I have to uncheck missing ones and check the new lowercase ones

Third time when again the files comes in uppercase with no whitespaces, my columns doesn't get identified as in the second time I had marked them uncheck since they were missing.

Can this be handled in alteryx?

[mceleavey]

Hi @hf14 ,

Can you please provide some example data so we can see the problem?

M.

[hf14]

Hi @mceleavey 

I have a file with 2 versions. 

This the select configuration when I load File-v1

This is the config when I load File-v2

Even though the column name is same, the second one is lowercase and with space so it doesn't get identified

I uncheck the missing uppercase ones and check the lowercase ones.

But then when I get third time get the file and it comes in uppercase format like the first one, the config looks like the below. Why it doesn't automatically ticks the correct uppercase ones? 

Here I can do the check uncheck thing, but in my real data set, there are around 400 columns. Which is hard to manually look for missing ones and check its alternate uppercase one.

[mceleavey · Accepted solution]

Hi @hf14 ,

I've attached a workflow which handles both inputs by standardising the column headers to be upper case and with no spaces. From there you can use a select tool or a Dynamic Rename tool to apply your naming conventions. The important thing is the standardisation of the column headers:

I hope this helps.

M.

[hf14]

Thanks this worked!

[mceleavey]