Hi,
I'm trying to use the field function in o/p derivation of pivot stage
FIELD(ERR1,'~',1)
and its giving error, can we use field function or any other equilent to it in o/p derivation of pivot stage.
Rgds,
Pivot stage derivation
Moderators: chulett, rschirm, roy
Re: Pivot stage derivation
Nope you cannot. Any derivation needs to be computed in a transformer and stored as a column prior to pivot.
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.