I have implemented looping in transformer but I was able to achieve the following and yes I have checked the other posts but couldn't really get the solution.
No, this is just a horizontal pivot. I don't see any need off the top of my head for transformer looping and there are other posts here that discuss how to pivot 'column headings' along with their associated data.
Create 59 new columns in the transformer with whatever values you need for each "questions" and pivot them along with their associated columns. I'll see if I can find an example where this is already illustrated.
Last edited by chulett on Tue Dec 23, 2014 4:53 pm, edited 1 time in total.
-craig
"You can never have too many knives" -- Logan Nine Fingers
Thanks for the response chulett. I have achieved this in transformer looping with a simple If then else logic using @iteration variable. Earlier I used horizontal pivot through pivot stage but I was not able to able to pivot the responses. By using the same logic for responses I pivoted those as well in the looping.
Thanks for the response rschirm. I have tried with pivot enterprise stage in which I was able to pivot the questions but couldn't pivot the responses as they are getting pivoted along with the questions as they are interrelated.
You may have achieved this using transformer looping but what did you actually achieve? Not the desired end result. As already noted, it's a horizon pivot of columns to rows.
-craig
"You can never have too many knives" -- Logan Nine Fingers
As you are hard coding Q1A Q1B Q1C, do you have only 3 columns you need to pivot? then why not just take 3 output from and transformer and funnel it back?
And as already noted multiple times by Craig, Its a horizontal pivot.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.