Adding Columns to Existing DataTable Programatically

Question

Are there any other possible ways to add columns to a data table within Spotfire, besides the method mentioned here: Spotfire add column from python list? I'm asking because the method works for a particular field that I have, except when the values are NULL (obviously cannot perform a join operation on a field, which is NULL).

If the join is the problem, why not use some sort of NullIF or IsNull function to force a value and satisfy the join? — S3S, Jun 27 '17 at 21:22

score 0 · Accepted Answer · answered Jun 28 '17 at 20:39

0

I was able to solve the issue through creating a calculated column that uses the row IDs to perform the join so the nulls would never interfere with the join.

answered Jun 28 '17 at 20:39

George Taki

11
4

I think it's best you close this question – S3S Jun 29 '17 at 02:46

Adding Columns to Existing DataTable Programatically

1 Answers1