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
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
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.
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?
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?
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.
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.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.