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

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?

Workflow

Input

Reporting

Regex

Dynamic Processing

Accepted answers

mceleavey

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.

mceleavey pivot.yxmd

All comments

mceleavey

Hi @hf14 ,

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

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.

FileA_v2.xlsx

FileA_v1.xlsx

mceleavey

Hi @hf14 ,

I hope this helps.

mceleavey pivot.yxmd

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703