- Data Integration
- All Products
Configure a field rule to prefix all incoming fields with "
agg_" so that the aggregated fields have unique names.
Group by the field
Create one aggregate field with the following properties to return the latest trading time for each stock ID:
Configure the following expression:
Configure the following field rules:
The list of included fields shows all the source fields: PRICE, STOCK_ID, TRADETIME, VOLUME
Add the following target fields: STOCK_ID and PRICE
Perform an automap with
Exact Field Name. This maps the incoming fields STOCK_ID and PRICE to the target fields STOCK_ID and PRICE.
Updated May 22, 2023