I got the following error message in Modeler when trying to use a previous created field in Modeler:
*”Unable to run stream as one or more stream nodes do not support SQL pushback.”
Formula in Node DELTA_P1FJT_LAT:
MAX(SEND_DATE, I_DESC_P1FJT_LAT, [T_CHASSIS SEND_DATE], ‘desc’,’rows’, -1,0) – MIN(SEND_DATE, I_ASC_P1FJT_LAT, [T_CHASSIS SEND_DATE], ‘asc’,’rows’, -1,0)
Formula in Node I_DESC_P1FJT_LAT
COUNT(P1FJT_LAT,T_CHASSIS,SEND_DATE,’desc’,’rows’,-1,0)
![alt text][1]
[1]: /answers/storage/temp/12299-cuserst070709desktop2017-02-01-08-59-24.jpg
I don’t know if I’m missing something, or if these formulas doesn’t support this?