transformations

What are key columns for linked data?

  • Have you noticed key columns for linked data in Data Table Properties and just want to know more?
  • Have you tried to use replace value transformations but found options grayed out (screenshot above)?
  • Have you ever lost the marked data behind tags when opening or closing a file?
  • Would you like to be able to edit values in a data table?

If any of these apply, read on to find how what key columns are and how to use them.

Read More »What are key columns for linked data?

Pro Tip No 4 How to Change Multiple Column Names At Once

In Spotfire, there are two ways to change column names. You can modify the column names in Column Properties, or you can change them with Transformations. There are ramifications for which method you use, which I explained in this Data Shop Talk post. Now, speaking to Transformations….For years, I’ve been under the impression that you could only ever change one column name at a time. However, I recently found out that is not the case. It is possible to formulaically change multiple column names in one fell swoop (or expression…as it were). Let me show you how!

Read More »Pro Tip No 4 How to Change Multiple Column Names At Once