3 Replies Latest reply: Apr 11, 2018 7:25 AM by Zyg D. RSS

    Adding a usable column to a data table

    Zyg D.

      I want to add another column to my data so that I could actually use it. I added a calculated field, but now I cannot select it in my app. Then I reloaded my same data from Excel (but this time I used script and appended the column that I need manually). But now I have 2 data tables! I don't want to rewrite my app based on the fields of the new table.

       

      For instance, I may want a new field where values would be concatenated from 2 other fields. I can create that by using 'calculated field' functionality. But then I cannot the use this new field as dimension in my graphs...

       

      There must be some easy way to add a column (so that I could use it in my app) to my old table, which I don't yet know... :/