I can´t use previous created field in a Derive field node

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?

Related:

Leave a Reply