Split dataset into 2 datasets based on Boolean column

Ignition
1

I’ve racked my brain with this a bit, and I haven’t come up with a solution that isn’t messy. The dataset has three columns, but I only want the first column split up into 2 datasets by the Boolean column which is column 3. So if Boolean is true then this item goes into dataset 1, else it goes to dataset 2. thanks

2

Not sure how messy is defined in this context, but this seems pretty short and sweet. And mostly painless.

Filter to 2 Tables_2018-12-07_1518.proj (28.6 KB)

2018-12-07_15-17-21.png792×596 10.4 KB

propertyChange script:

if event.propertyName == 'data':
  dataIn = system.dataset.toPyDataSet(event.source.data)
  trueTable = event.source.parent.getComponent('True Table')
  falseTable = event.source.parent.getComponent('False Table')
  
  headers = ['value']
  trueData = []
  falseData = []
  
  for row in dataIn:
    if row['Boolean Column'] == True:
      trueData.append([row['String Column']])
    else:
      falseData.append([row['String Column']])

  trueTable.data = system.dataset.toDataSet(headers, trueData)
  falseTable.data = system.dataset.toDataSet(headers, falseData)
2 Likes
3

I think @JordanCClark did it better, but:

# set up a dataset to run this against
headers = ["H1", "H2", "H3"]
 
data = []
data.append(["a", 1, True])
data.append(["b", 2, False])
data.append(["c", 3, True])
data.append(["d", 4, False])
data.append(["e", 5, True])
 
dataset = system.dataset.toDataSet(headers, data)

# here's the actual logic
pds = system.dataset.toPyDataSet(dataset)

trueData = [[row[0]] for row in pds if row[2] == True]
falseData = [[row[0]] for row in pds if row[2] == False]

trueDataSet = system.dataset.toDataSet(["H1"], trueData)
falseDataSet = system.dataset.toDataSet(["H1"], falseData)
1 Like
4

This was what I was leaning towards, I just hit a wall and couldn’t finish my logic. Thankfully it is Friday!!

5

I figured it was a Friday thing.

6

What is the need for this line?

7

Wait, is that so it only runs when the data property has changed?

8

You got it, my friend!

1 Like