Skip to main content
  • Home
  • Forums
  • FME Form
  • General
  • I have filtered air temp into average daily max and min. And I would like to display them in two columns filtered by date and station. In the final table, only the max temp is showing in both columns. How do I show min temp as well?
Solved

I have filtered air temp into average daily max and min. And I would like to display them in two columns filtered by date and station. In the final table, only the max temp is showing in both columns. How do I show min temp as well?

R
I have filtered air temp into average daily max and min. And I would like to display them in two columns filtered by date and station. In the final table, only the max temp is showing in both columns. How do I show min temp as well?

Best answer by jdh

OK. It looks like what you want to do is after your Feature Reader have a tester for ParameterTypeLongName = Air Temperature, then your DateFormater (this is a performance thing, why format dates that you are not going to use)

Then an attributeCreator @Value(TimeSeriesName) = @Value(Value). This should give an attribute of either A.DayMax or A.DayMin depending on which row/feature it is.

Then an Aggregator with a group by on StationName and MeasureDate, in Accumulation Mode Merge Incoming Attributes

That will get both the max and min temp attributes on the same feature. You can then do any cleanup of attribute names (this may require an attributeExposer).

View original
    Did this help you find an answer to your question?

    16 replies

    danilo_fme
    Evangelist
    Forum|alt.badge.img+41
    • danilo_fmeEvangelist
    • Evangelist
    • March 13, 2021

    Hi @robeesafe​ 

    please, could you share the data?​

    jdh
    Contributor
    Forum|alt.badge.img+28
    • jdhContributor
    • Contributor
    • March 15, 2021

    We would need to know the settings on your workspace to be able to help.

    R
    • robeesafe
    • Author
    • March 15, 2021
    danilo_fme wrote:

    Hi @robeesafe​ 

    please, could you share the data?​

    Hello Danilo, I have attached the weather dataset from which I would like to filter the “Air Temperature” out of “ParameterTypeLongName” and further filter A.DayMax and A.DayMin from “TimeSeriesName” to display as indicated in “tmp.csv”. Here is an image of the transformers I used: [cid:image001.png@01D71981.4FD5DB90] Let me know if you have any questions. Thanks, Robert Classification: Protected A
    R
    • robeesafe
    • Author
    • March 15, 2021
    jdh wrote:

    We would need to know the settings on your workspace to be able to help.

    Hello JDH, I have attached the weather dataset from which I would like to filter the "Air Temperature" out of "ParameterTypeLongName" and further filter A.DayMax and A.DayMin from "TimeSeriesName" to display as indicated in "tmp.csv". Here is an image of the transformers I used: [cid:image001.png@01D71981.4FD5DB90] Let me know if you have any questions. Thanks, Robert Classification: Protected A
    jdh
    Contributor
    Forum|alt.badge.img+28
    • jdhContributor
    • Contributor
    • March 15, 2021
    robeesafe wrote:
    Hello JDH, I have attached the weather dataset from which I would like to filter the "Air Temperature" out of "ParameterTypeLongName" and further filter A.DayMax and A.DayMin from "TimeSeriesName" to display as indicated in "tmp.csv". Here is an image of the transformers I used: [cid:image001.png@01D71981.4FD5DB90] Let me know if you have any questions. Thanks, Robert Classification: Protected A

    Hi Robert,

     

    I'm not seeing either the image or the attached csv.kb_view

    R
    • robeesafe
    • Author
    • March 15, 2021
    robeesafe wrote:
    Hello JDH, I have attached the weather dataset from which I would like to filter the "Air Temperature" out of "ParameterTypeLongName" and further filter A.DayMax and A.DayMin from "TimeSeriesName" to display as indicated in "tmp.csv". Here is an image of the transformers I used: [cid:image001.png@01D71981.4FD5DB90] Let me know if you have any questions. Thanks, Robert Classification: Protected A
    Hello JDH, I'm resending my earlier message with attachments. I have attached the weather dataset from which I would like to filter the "Air Temperature" out of "ParameterTypeLongName" and further filter A.DayMax and A.DayMin from "TimeSeriesName" to display as indicated in "tmp.csv". I have also appended an image of the transformers I used. Let me know if you have any questions. Thanks, Robert Classification: Protected A
    R
    • robeesafe
    • Author
    • March 18, 2021
    danilo_fme wrote:

    Hi @robeesafe​ 

    please, could you share the data?​

    Hello Danilo, Do you have any questions for me? I’m wondering if you have made on progress on the request. Best regards, Robert Classification: Protected A
    R
    • robeesafe
    • Author
    • March 18, 2021
    jdh wrote:

    We would need to know the settings on your workspace to be able to help.

    Hello JDH, Do you have any update for me? Thanks, Robert Classification: Protected A
    jdh
    Contributor
    Forum|alt.badge.img+28
    • jdhContributor
    • Contributor
    • March 18, 2021
    robeesafe wrote:
    Hello JDH, Do you have any update for me? Thanks, Robert Classification: Protected A

    Hi Robert, I am not sure how you are sending the attachments, but they are not showing up in this forum.

    R
    • robeesafe
    • Author
    • March 18, 2021
    robeesafe wrote:
    Hello JDH, Do you have any update for me? Thanks, Robert Classification: Protected A
    Hello JDH, I'm sending them as attachments to this email. Is there another way? Thanks, Robert Classification: Protected A
    jdh
    Contributor
    Forum|alt.badge.img+28
    • jdhContributor
    • Contributor
    • March 18, 2021
    robeesafe wrote:
    Hello JDH, Do you have any update for me? Thanks, Robert Classification: Protected A

    Use the web interface. You can embed images and attach a file to your reply.

    R
    • robeesafe
    • Author
    • March 18, 2021

    Here is one of the attachments. How do I send an Excel and csv file?Air Temp transformers

    R
    • robeesafe
    • Author
    • March 18, 2021

    Example of air temperature source data

    R
    • robeesafe
    • Author
    • March 18, 2021

    Desired air temp output

    jdh
    Contributor
    Forum|alt.badge.img+28
    • jdhContributor
    • Contributor
    • Best Answer
    • March 18, 2021

    OK. It looks like what you want to do is after your Feature Reader have a tester for ParameterTypeLongName = Air Temperature, then your DateFormater (this is a performance thing, why format dates that you are not going to use)

    Then an attributeCreator @Value(TimeSeriesName) = @Value(Value). This should give an attribute of either A.DayMax or A.DayMin depending on which row/feature it is.

    Then an Aggregator with a group by on StationName and MeasureDate, in Accumulation Mode Merge Incoming Attributes

    That will get both the max and min temp attributes on the same feature. You can then do any cleanup of attribute names (this may require an attributeExposer).

    R
    • robeesafe
    • Author
    • March 18, 2021

    Thanks, your solution worked.

    Reply


    Helpful Members This Week

    Community Stats

    30,938
    Posts
    117,250
    Replies
    38,740
    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.