Pro Tip

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 5 Document Calculated Columns with Numbering

All of the projects I’ve worked in the last year have been big, behemoth projects. As I build, I try to document as much as possible. One area that continues to be complicated and time-consuming to document are calculated columns. As a result, I’ve started to document calculated columns with numbering. This post will explain how and why this simple tactic will make understanding your work months later much easier.

Read More »Pro Tip No 5 Document Calculated Columns with Numbering

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