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 :)
