How to Show unique values from a column which is unmarked

[Sanandh C k]

I have marked some data in dashboard , I want to show the unique values from a particular column which is unmarked in text area. Is it possible

[Sanandh C k]

Here is the Answer for above question:

from System.Collections.Generic import List

from Spotfire.Dxp.Data import *

cursor = DataValueCursor.CreateFormatted(dataTable.Columns["City"])

markings = Document.ActiveMarkingSelectionReference.GetSelection(dataTable)

rowCount=dataTable.RowCount

MarkedRowIndex=List[int]();

markedata = List [str]();

for i in markings.AsIndexSet():

MarkedRowIndex.Add(i)

print MarkedRowIndex #RowIndex

for row in dataTable.GetRows(cursor):

if row.Index not in MarkedRowIndex:

print row.Index

value= cursor.CurrentValue

if value str.Empty:

markedata.Add(value)

valData = List [str](set(markedata))

SelectedValues= ', '.join(valData)

 

print SelectedValues

Document.Properties["SelectedValues"]=''

Document.Properties["SelectedValues"]=SelectedValues