Skip to main content
Question

Transposing Using the postcode and question number as a pair, possibly a list?

sar_copp
Contributor
Forum|alt.badge.img+4

Morning, I am trying to transpose some data from a survey, I want to sort of Pair up the Postcode and the Question Number, then have columns of Responses with counts. Ive attached images  and a fme workbench of the original data and the output I want. I have 36 questions, so want to know if there is a way to do this using a list? So I dont have to repeat this 36 times, I am not understanding how to do lists!
I want to output the postcode as a column, then have a question number column. So each postcode will be repeated depending on the number of questions e.g.

Question No    Postcode

Question 1      M19 4NY

Question 2     M19 4NY

Question 1      M4 7AT

Question 2     M4 7AT

 

Then I want the next columns to be counts of the answers

Question No    Postcode  Strongly Agree      Agree      Neither    Disagree     Strongly Disagree

Question 1      M19 4NY             2                         3               1               0                      2

Question 2     M19 4NY             5                         7               0                3                      0

Question 1      M4 7AT             1                          2                1               5                       6

Question 2     M4 7AT               3                         4                 1              4                       4

 

1 Attachments

2 replies

jkr_wrk
Influencer
Forum|alt.badge.img+29
  • jkr_wrkInfluencer
  • May 2, 2024

@sar_copp Is this question still open?

I think your data looks pretty good for an excel pivot table to get the results you want.

But this will give the result in fme:

 

💡 Did you know... The FeatureWriter is more intuitive. 😏
liamfez
1 person upvoted this
  • liamfez
    liamfez
sar_copp
Contributor
Forum|alt.badge.img+4
  • sar_coppContributor
  • Author
  • Contributor
  • May 2, 2024
jkr_wrk wrote:

@sar_copp Is this question still open?

I think your data looks pretty good for an excel pivot table to get the results you want.

But this will give the result in fme:

 

I am indeed looking for the answer - my excel screen print was just an illustration of what I need, havent managed to achieve it. Will look at what yo’ve done

Reply


Helpful Members This Week

Community Stats

31,290
Posts
118,678
Replies
38,878
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.