Knowledge Base - All Comments

re: Using pivot and self-joins to prepare data using the API

Jonas Svensson — Mon, 06 Dec 2010 20:34:00 GMT

Yes, it is possible to convert this to an iron python script, here is a version of the same code in iron python assuming that "table" is a DataTable parameter to the script:

from Spotfire.Dxp.Data.Import import *

from Spotfire.Dxp.Data import *

from Spotfire.Dxp.Data.Transformations import *

from Spotfire.Dxp.Application.Visuals import *

from System.Collections.Generic import *

dtds = DataTableDataSource(table)

pivot = PivotTransformation()

connection = dtds.Connect(Application.Document, DataSourcePromptMode.None)

reader = connection.ExecuteQuery2()

sellerSignature = DataColumnSignature(reader.Columns["Seller"])

customerSignature = DataColumnSignature(reader.Columns["Customer"])

salesSignature = DataColumnSignature(reader.Columns["Sales Amount ($)"])

pivot.IdentityColumns = [sellerSignature, customerSignature]

pivot.TransferColumns = [ColumnAggregation(salesSignature, "sum")]

reader.Dispose()

connection.Dispose()

builder = DataFlowBuilder(dtds, Application.ImportContext)

builder.AddTransformation(pivot)

dataFlow = builder.Build()

uniqueName = Application.Document.Data.Tables.CreateUniqueName("Data Table (Pivot)")

transformedTable = Application.Document.Data.Tables.Add(uniqueName, dataFlow)

leftCustomer = DataColumnSignature(transformedTable.Columns["Customer"])

connection = dataFlow.Connect(Application.Document, DataSourcePromptMode.None)

reader = connection.ExecuteQuery2()

rightCustomer = DataColumnSignature(reader.Columns["Customer"])

reader.Dispose()

connection.Dispose()

mapping = Dictionary[DataColumnSignature,DataColumnSignature]({leftCustomer:rightCustomer})

addColumnsSettings = AddColumnsSettings(mapping, JoinType.FullOuterJoin, [])

transformedTable.AddColumns(dataFlow, addColumnsSettings)

page = Application.Document.Pages.AddNew("Transformed table")

page.AutoConfigure()

plot = page.Visuals.AddNew[TablePlot]()

plot.Data.DataTableReference = transformedTable

plot.AutoConfigure()

re: Using pivot and self-joins to prepare data using the API

JTR — Mon, 06 Dec 2010 16:36:37 GMT

Is it even possible to convert this to IronPython?

re: Creating a file based “on-demand” using data functions

Greg Goldsmith — Mon, 01 Nov 2010 19:12:12 GMT

re: Use the TIBCO Spotfire S+ Server Java API to Develop a Web Application

Anonymous — Tue, 20 Jul 2010 12:29:30 GMT

Thanks a lot for the information

re: Implementing a Test Harness Using Automation Services

Mark Harris — Mon, 21 Jun 2010 14:45:30 GMT

Note that as of version 3.1, the Package Builder appears to pick up the reference to Automation Services automatically. You can omit the step 3 in "Set up the Package Builder Configuration for Local Testing" which adds TIBCO Spotfire Automation Services into the active configuration, or you might find that an exception occurs.

190d Part 1981 Mercedes, 190d Car Buyer - 259.defutbolazo.com

190d Part 1981 Mercedes, 190d Car Buyer - 259.defutbolazo.com — Tue, 25 May 2010 18:17:06 GMT

Pingback from 190d Part 1981 Mercedes, 190d Car Buyer - 259.defutbolazo.com

Ramcharger Coupon Oem, Aftermarket Rebel Xt Charger - 100.tgrconversions.com

Ramcharger Coupon Oem, Aftermarket Rebel Xt Charger - 100.tgrconversions.com — Tue, 25 May 2010 17:52:10 GMT

Pingback from Ramcharger Coupon Oem, Aftermarket Rebel Xt Charger - 100.tgrconversions.com

Es330 Parts Buy Lexus Brake Rotors, Es330 Removal Heater - 390.myipgirl.com

Es330 Parts Buy Lexus Brake Rotors, Es330 Removal Heater - 390.myipgirl.com — Tue, 25 May 2010 17:52:09 GMT

Pingback from Es330 Parts Buy Lexus Brake Rotors, Es330 Removal Heater - 390.myipgirl.com

Miranda Mx3, 1992 Mazda Mx3 Precidia Review - 452.tgrconversions.com

Miranda Mx3, 1992 Mazda Mx3 Precidia Review - 452.tgrconversions.com — Tue, 25 May 2010 17:51:47 GMT

Pingback from Miranda Mx3, 1992 Mazda Mx3 Precidia Review - 452.tgrconversions.com

Buy Medallion Fiberglass, Medallion Buy Should - 238.myipgirl.com

Buy Medallion Fiberglass, Medallion Buy Should - 238.myipgirl.com — Tue, 25 May 2010 17:43:10 GMT

Pingback from Buy Medallion Fiberglass, Medallion Buy Should - 238.myipgirl.com

Used Cadillac Seville Pictures Volvo S80, Seville Discount Spain Vincci La Rabida Petit Palace Marques Santa Ana - 457.zapstreaming.com

Tue, 25 May 2010 17:33:59 GMT

Pingback from Used Cadillac Seville Pictures Volvo S80, Seville Discount Spain Vincci La Rabida Petit Palace Marques Santa Ana - 457.zapstreaming.com

B3500 Obituaries, Cheap Dodge B3500 Van - 26.renters.ws

B3500 Obituaries, Cheap Dodge B3500 Van - 26.renters.ws — Tue, 25 May 2010 17:30:58 GMT

Pingback from B3500 Obituaries, Cheap Dodge B3500 Van - 26.renters.ws

D21 Wholesale Black High Quality, Axxess Headlight Honda Salvage Yards D21 - 30.binggreen.com

Tue, 25 May 2010 17:27:16 GMT

Pingback from D21 Wholesale Black High Quality, Axxess Headlight Honda Salvage Yards D21 - 30.binggreen.com

Ln7 Blower Air Conditioner, Free Shipping Mercury Ln7 - 49.dlmreza.net

Ln7 Blower Air Conditioner, Free Shipping Mercury Ln7 - 49.dlmreza.net — Tue, 25 May 2010 17:26:55 GMT

Pingback from Ln7 Blower Air Conditioner, Free Shipping Mercury Ln7 - 49.dlmreza.net

E 450 Super Duty Full 2008 Ford F 550, John Deere Frontier Rear Bumper Heavy Duty - 82.luna-atra.net

Tue, 25 May 2010 17:24:36 GMT

Pingback from E 450 Super Duty Full 2008 Ford F 550, John Deere Frontier Rear Bumper Heavy Duty - 82.luna-atra.net