Customer Banners (Ads) - SpiceUp. AX and SpotfireX Disclaimer



If you find this site useful and you want to support, buy me a coffee   to keep this site alive and without ads.

Change a join after inserting a column

from Spotfire.Dxp.Data import *
from Spotfire.Dxp.Data.DataOperations import *
from System import *

#Join Types
i   = 'InnerJoin'
lo = 'LeftOuterJoin'
ro = 'RightOuterJoin'
fo = 'FullOuterJoin'
ls = 'LeftSingleMatchJoin'
rs = 'RightSingleMatchJoin'

joinType = lo
matchOnNull = 0

op = table.GenerateSourceView().GetAllOperations[AddColumnsOperation]()[0]
old = op.AddColumnsSettings;
newSettings = AddColumnsSettings(old.Map, Enum.Parse(JoinType, joinType), old.IgnoredColumns, matchOnNull)
op.AddColumnsSettings = newSettings

source: https://community.tibco.com/wiki/how-change-join-type-add-columns-operation-tibco-spotfire-using-ironpython

No comments: