Mandar Kavishwar 6 Posted January 4, 2019 Share Posted January 4, 2019 While creating cross table in Spotfire , The cell values get grouped, Can we ungroup the values to display them on each row Current and Expected output is attached. I am using Spotfire 7.11 Link to comment Share on other sites More sharing options...
Gaia Paolini Posted January 4, 2019 Share Posted January 4, 2019 Hi Please can you provide the input data and the Spotfire sample dxp you used for the current output Thanks Gaia Link to comment Share on other sites More sharing options...
Mandar Kavishwar 6 Posted January 8, 2019 Author Share Posted January 8, 2019 Hi, While i cant attach the data and DXP file, i have given the sample data with Current and expected output. Please see the attached excel. Link to comment Share on other sites More sharing options...
Gaia Paolini Posted January 8, 2019 Share Posted January 8, 2019 Hi Thanks. Col1, Col2 and Value, already look like the desired result when displayed in a plain table. I don't understand why you need a cross table. Regards Gaia Link to comment Share on other sites More sharing options...
Mandar Kavishwar 6 Posted January 8, 2019 Author Share Posted January 8, 2019 Yes you are correct. But the problem is - I am using external data and when i connect to data table and select it as Table Viz, Marking does not work. It says " There is no primary key in external database" . But we do have key properly defined in external DB. So as a work around i thought of using cross table. Link to comment Share on other sites More sharing options...
Khushboo Rabadia Posted January 8, 2019 Share Posted January 8, 2019 You can try to insert row number as first column and then rest of the columns like below. My data is imported so I have just used RowId() function for rownumber. You can create calculated column on external data or have that column in your database: Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now