Hi there -
Does anyone know how to combine Substitute and filter functions on Gallery Items? I would like to substitute certain values in my data and then filter on the columns where I substituted the values.
Many thanks
Hi @Anonymous,
Could you please share a bit more about your need?
Do you want to replace some value in a column and then filter based on the changes?
I want to explain to you that the Substitute() function could only replace strings within an existing string or a single column table. It does not operate on all the columns within a Data Source.
If you want to operate on multi columns, please convert it into a single column table.
Share
Report
All responses (
Answers (
411
