Unpivot option is disable for me. I have attached screenshot. Thank you in advance

[Venkata Siva Komma]

[Fredrik Rosell]

Hello,

The Unpivot option in the Data Panel has the following requirements:

* For it to show up at all, you must have the appropriate license (and you already do, as it's visible but simply not enabled)

* For it to be enabled:

* You must have selected at least two columns (and from your screenshot, you have)

* The columns cannot be calculated 

* The columns must be from the same data table

* The data table must be an in-memory data table

So, considering this, and the "Split"-suffix in your column names, I assume you have used the "Split" functionality to split the Readout column, which results in calculated columns, which would explain why Unpivot is not enabled.

Depending on your needs, there are various ways around that. You could e.g.:

• Add the split yourself as transformations during the initial import of the data (e.g. manually add a "calculate new column" for each of the splits, with an expressions like Split([Readout],",",1) for the first one, Split([Readout],",",2) for the second etc. With the data imported in that way, you would then be able to perform operations like Unpivot on it after the import. You can read more about transformations upon data loading or afterwards here: https://docs.tibco.com/pub/sfire-analyst/12.0.1/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=data%2Fdata_transforming_data.htm&rhsearch=transformation&rhhlterm=transformation&rhsyns=%20
• Note that you could now also consider doing the Unpivot as a transformation step, just like above.
• If you don't want to add transformation steps for the initial import, if you freeze the columns, Unpivot should become enabled (but read up on the side-effects of freezing a column here: https://docs.tibco.com/pub/sfire-analyst/12.0.1/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=data%2Fdata_details_on_column_properties_general.htm&rhsearch=freeze&rhhlterm=freeze&rhsyns=%20)

Best Regards

Fredrik

[Venkata Siva Komma]

Hi Fredrik

Thank You So much

I will go through

Best Regards

Siva

[Rafael Barros 2]

@Venkata Siva Komma​ If your dataset is not huge, you may also consider to create a new table (going to Files and data... Other) after you do the split to convert the calculated columns (split) - Then you do the Unpivot in the new table. With this workaround, if you replace the raw-data with a new one (for example, Q2 data to replace Q1) all the cleaning will work smoothly.