I have a table with a lot of different columns in tableau. Each column has a calculated field.
I need to make about 15 more of these tables. Each one of these tables is nearly identical to the first, except that one flag is different in some fields, and other fields are named off of THOSE fields.
For example, I already have a table called "M Status now Active". Each calculated field is named "MSNA {field title}". Inside each calculation is something like "... AND status='active'"
How can I clone all of these fields, and the replace "MSNA" with another entry, such as "MSNI", and "active" with another entry, such as "Inactive"?
If I can figure out how to find and replace patterns in bulk, this will save me days of manually copying entries in Tableau.
All I want is to duplicate all fields which contain a certain pattern, but with a replaced version of that pattern. Like if I was using "sed".
Please help! When I look at a workbook in the filesystem, it is very hard to determine what I would have to modify.
I am very lost as to how I can do this in Tableau as I would if I were using any other technology.
Thanks!