Article - CS398533

Aquire unique column data for a DataTable in ThingWorx Platform

Modified: 25-Aug-2023   


Applies To

  • ThingWorx Platform 9.1 to 9.4

Description

  • Expect to get data of special columns of ThingWorx DataTable and remove repeated data
  • For example, there is DataTable with below columns and data
    • User hope to acquire unique data of Value column with condition that No column is "A".
    • So the result should be 2 rows with Value as "test1" and "test2"
    • IDValueNo
      1test1A
      2test2B
      3test1B
      4test2A
      5test1A
This is a printer-friendly version of Article 398533 and may be out of date. For the latest version click CS398533