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.

Capture_01.PNG

Capture_02.PNG

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.