Need to create Identity field base on multiple columnd

[nomvulam]

I need to be able create an ID field where work orders have the same Site,Section and Date  in load script

[MatheusC]

Hi @nomvulam 
Look like this:

Date &' '& Site &' '& Section as NewField

- Matheus

[nomvulam]

Thank you for the response, how to now count the work orders based on the Newfield grouping where work orders appear more than once

[MatheusC]

Prefixing distinct to your count Count (Distinct NewField)