Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Header changes in input file, how to map standardized header to that field

wonka1234
10 - Fireball

Hi,

 

My header this week of my input file could be Issue ID 123, next week could be Issue ID 456 and so on.

 

How can I map this header name to a standard header "Issue ID" all within alteryx?

 

Thanks.

1 REPLY 1
Raj
14 - Magnetar

Add a dynamic rename tool in starting just after input and make 
if Contains([_CurrentField_],"Issue ID") then "Issue ID" else [_CurrentField_] endif

this will work

Labels