I added a new table to my dashboard and transformed the table with "Pivot" so that I have the pivoted values that I needed. I would like then like to join another table to this new pivoted table. It doesnt appear that I can do this in spotfire.

[Rick V]

Is there a workaround for this ? Thank you for any help

[Kirsten Smith (she/her)]

I did a quick test and was able to Add Columns to a table that had a 'Pivot' transformation with no issues. What exactly happens when attempt this? Any warnings or error messages?

[Rick V]

Hi Kirsten,

 

Thank you for looking at my question. I was off Friday so couldnt get back to you.

 

 

1. So, lets say my new pivoted table is called "Table B". And I

have an existing table called "Table A"

2. I want to left outer join "Table A" to "Table B" (Not "Table B"

to "Table A")

3. When I go to join "Table A" to "Table B", "Table B" is not

available to choose from.

 

 

Hopefully, I am explaining it correctly

 

Thanks again

 

Rick v.

[Kirsten Smith (she/her)]

Unfortunately I'm still not able to reproduce the problem. Here's a screen shot of what I have done, showing the data canvas where I'm joining Table A to Table B.

What steps did you use to create the Pivot table (Table B)? Data/Transform Data?

[Kirsten Smith (she/her)]

You might also want to create a support ticket at https://support.tibco.com to get more in-depth assistance.

[Rick V]

Kirsten,

 

Thanks so much for getting back to me, I finally figured it out today and it was my fault. To get to my newly created "Pivot Table", I have to click on "Other", sheesh.

 

Appreciate you helping , Thank you

 

 

[image: image.png]

[Vivek Kumar 10]

One simple, not best, but working solution I may propose.

Use Data Function (Python/TERR) to create a new Data Table from Pivoted using simple code

output=input

input will be of type Table and output as table as well. This will create a copy of pivoted table and it will be working as any normal table now.

Note: Keep data function to refresh automatically.