Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Dynamic Select - Multiple Columns

furlonla
8 - Asteroid

Hi,

 

I am looking for a way to dynamically select multiple columns using the contains expression. Currently I have this and it is working for that criteria:

furlonla_0-1637671562898.png

However, I would also like the output to contain any columns that have the word 'Total' in them. I am not sure how to type this expression or if it is possible.

 

Any help on this would be really appreciated.

 

Thanks,

Laura

 

4 REPLIES 4
TheOC
15 - Aurora
15 - Aurora

hi @furlonla 

Please try the following as your formula:
Contains([Name], 'GROSS , MASTER, Gross, P&L') or Contains([Name], 'Total')

 

 

the function OR allows it to select, if it meets either criteria (or both).

 

Cheers,
TheOC


Bulien
mbarone
16 - Nebula
16 - Nebula

Do you mean any column with the word Total in the column name, or do you mean any column with at least one VALUE of "Total"?

furlonla
8 - Asteroid

This worked, thank you

Bhanu04
6 - Meteoroid

I am trying to do the latter and unable to get correct results. tried something like this

 

if contains(tostring([name]= 'abc'),'ghj)

then  [fieldnumber] in (2)

else  [fieldnumber] in (3)

endif

 

this works perfectly in a formula tool but agenda is to dynamically select columns.

Labels