I think the issue was by ths following , I want to produce a label for a data record, listing the Year and Quarter, e.g., 2014-Q2. , The following derivation performs sufficiently:
If (DataSet.MONTH < 4) Then DataSet.YEAR:"-Q1" Else If (DataSet.MONTH > 3 AND DataSet.MONTH < 7) Then DataSet.YEAR:"-Q2" Else If (DataSet.MONTH > 6 AND DataSet.MONTH < 10) Then DataSet.YEAR:"-Q3" Else DataSet.YEAR:"-Q4"
With these it helps Yes this could be solved within a transformer stage. Concatenation is done with ":". So use a stage variable to concat the input until a new "Meter" or "Customer" row comes up. Save the "Customer" in a second stage variable in case it does not change.
Symfony2 form field constraints validation before Data Transformer