Filter Columns based on headline

[df]

Hello,

I used the "Join Multiple" Tool to put some tables togehter.

I dont need every Columne here (only with "spend" in headline).

I know that i can just uncheck the columnes i dont need but i want a dynamic way.

Something like a filter:

For each Columne

   If contains(<columneheadline>,"spend")

   Then Columne is needed (not filtered)

   Else Columne is unneeded (filtered).

   Endif

Next

The Output of "join multiple" looks like this:

date	spend	Input_#2_date	Input_#2_spend	Input_#3_date	Input_#3_spend
...	...	...	...	...	...

I tried to use the "transpose" tool with "multi row Formular" tool (and filter).

Then my output looks like this:

spend	x
Input_#2_spend	...
Input_#3_spend	...
spend	y
Input_#2_spend	...
Input_#3_spend	...
spend	z

But then i have problems to transform it back

the output should look like:

spend	Input_#2_spend	Input_#3_spend
x	...	...
y	...	...
z	...	...

Maybe someone can help :)

[paul_houghton · Accepted solution]

Hi DF,

You can use the dynamic select tool with the formula option and drop the condition that you put in.

[df]

Hey,

that was easier than expected - thank you :)