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
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:
Post a Comment