Want to apply multiple transformation to different filter ordered data

[Dhruv_001]

Hi To All,

I have a scenario where I am applying multiple transformation to filter ordered data.

I want to apply same multiple transformation to multiple filter ordered data. I don't want to change the order and I don't want to repeat to apply the same transformation to all of the filter ordered data.

For example : 

I am applying the logics here to one filter data which is in order.  

sorted data ---- getting first and next value in new columns ---  avg rolling --- variance --- output

Same logics i want to apply to other filters. But I am looking to do transformation once to all filter without changing the order of my data.

[apathetichell]

not really seeing your issue. use recordid. use union to recreate your datastream. use sort as neeeded. apply your transformations before your filter? Maybe you need a batch macro.