I am trying to get distinct set of data from a document which is an input to a flow service. Ex.

# Document

# orderNo orderType lineNo itemNo quantity price

1001 SO 1 I1 10 1000

1001 SO 2 I2 11 110

2011 SO 1 I1 10 1000

2011 SO 2 I2 21 210

2011 SO 3 I3 22 4400

3021 SO 1 I2 10 100

3021 SO 2 I3 10 2000

Using SQL : select distinct <orderno> from <table> where <ordertype=‘so’>

will return

1001

2011

3021

Is there any way to implement the above concept using a Document, used as an input, to a flow service?

Thanks