Alteryx Designer Desktop Discussions

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

Multi-Field Formula to iterate through columns in data set

tomek1988231
6 - Meteoroid

Hi everyone, I need to create this workflow which allows to iterate through all columns in the data set and start some action if the coulmn name match from list (I can not select certain columns because I also iterate through diffrent columns form Data Base and deploy data into diffrent tabs). I think Multi Field Formula should do the job but I'm stuck on the expression, it seems it checks only first coulmn form the data. I've wrote something like this:

 

if _CurrentFieldName_ = IN( 'Col A', 'Col B', Col C')

then 'Red'

Else

_CurrentField_

EndIF

 

Can anyone advise?

1 REPLY 1
Qiu
20 - Arcturus
20 - Arcturus

@tomek1988231 
somehow it works on my side, with a bit of modification.

0329-tomek1988231.PNG

Labels