Skip to main content
Question

I have three columns of data: (Week, Year, Flow). I would like to pivot or transpose this data without any calculations or summary statistics. Year in rows, Week in columns and just fill in the corresponding flow values. Thanks for any help with thi


benadei
Participant
Forum|alt.badge.img+3

2023-10-25_12-58-20

6 replies

geomancer
Evangelist
Forum|alt.badge.img+51
  • Evangelist
  • October 26, 2023

Something like this?

Years_and_WeeksNote that you have to expose all attributes (all years).


benadei
Participant
Forum|alt.badge.img+3
  • Author
  • Participant
  • October 26, 2023

Yes, thanks for taking the time to help me out with your response. The only difference from your solution is that, I need the years in rows and the weeks in columns, but I think I can follow your suggestions to have it as I want. I will keep you posted on my progress. Thanks again.


geomancer
Evangelist
Forum|alt.badge.img+51
  • Evangelist
  • October 27, 2023

Ah yes, I see I misread your question a bit...

Years_and_Weeks_v2


benadei
Participant
Forum|alt.badge.img+3
  • Author
  • Participant
  • October 27, 2023

Thank you so much for taking the time again to provide me with the exact solution that I am looking for. I have attached a screenshot of my workspace and output from the AttributeExposer. My Week column labels all look like x.0. Any explanation for and how to fix this?2023-10-27_10-22-16


geomancer
Evangelist
Forum|alt.badge.img+51
  • Evangelist
  • October 30, 2023
benadei wrote:

Thank you so much for taking the time again to provide me with the exact solution that I am looking for. I have attached a screenshot of my workspace and output from the AttributeExposer. My Week column labels all look like x.0. Any explanation for and how to fix this?2023-10-27_10-22-16

Hi, I am not sure, but I think the week numbers in your input are defined as numbers with decimals (also known as "real numbers").

If you are using FME 2023, you can set the data type in the AttributeManager.

In an older version, it may help to calculate the integer value in the AttributeManager.


benadei
Participant
Forum|alt.badge.img+3
  • Author
  • Participant
  • November 1, 2023
geomancer wrote:

Hi, I am not sure, but I think the week numbers in your input are defined as numbers with decimals (also known as "real numbers").

If you are using FME 2023, you can set the data type in the AttributeManager.

In an older version, it may help to calculate the integer value in the AttributeManager.

Thanks a million for all the time you have spent helping me with my request and sharing your very useful knowledge. I appreciate your time and help immensely.


Reply


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