Skip to main content
Question

Counter behaving strangely

  • January 2, 2020
  • 8 replies
  • 29 views
A
Forum|alt.badge.img+1

Hi,

I am using FME 2019.1 and have encountered a strange issue with the Counter transformer.

I am getting the below value being returned in the _count attribute for some but not all records. Just prior to the Counter transformer I reversed the orientation of a few records and I have found that for those records which are reversed, I get the below value output, but for those which are not reversed, I get a normal number output. However, when I pass only the reversed records through the counter, I get normal number outputs. It doesn't seem to like the combination of reversed and non-reversed records!

@Value(__fme_ft_return_value112f8e69-4aa4-4f5f-9f81-f47c60797f64)

Has anyone seen this before?

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

8 replies

redgeographics
Celebrity
Forum|alt.badge.img+59
  • redgeographicsCelebrity
  • Celebrity
  • 3700 replies
  • January 2, 2020

Could you share a screenshot of your workspace so we have a better idea of what you're trying to do?

FME rocks! \m/
A
Forum|alt.badge.img+1
  • aquamarine
  • Author
  • 271 replies
  • January 2, 2020

Hi @redgeographics below is a screenshot.

 

Counter_4 is the one that outputs the strange values. Counter_3 works as normal.

redgeographics
Celebrity
Forum|alt.badge.img+59
  • redgeographicsCelebrity
  • Celebrity
  • 3700 replies
  • January 2, 2020

Hi @redgeographics below is a screenshot.

 

Counter_4 is the one that outputs the strange values. Counter_3 works as normal.

I can't seem to reproduce this, I've attached my little testcase if anybody else wants to take a stab at this (or if you want to send it in to Safe's support).

If you could try running that test workspace and see if you get the correct results that could actually be quite useful (it may be an issue with your source data)

Counter_issue.fmw

FME rocks! \m/
A
Forum|alt.badge.img+1
  • aquamarine
  • Author
  • 271 replies
  • January 2, 2020

I can't seem to reproduce this, I've attached my little testcase if anybody else wants to take a stab at this (or if you want to send it in to Safe's support).

If you could try running that test workspace and see if you get the correct results that could actually be quite useful (it may be an issue with your source data)

Counter_issue.fmw

Thanks for looking at this @redgeographics. I ran that workflow you sent through and it worked fine for me. But when I copied the transformers into my existing workflow and connected it up , I got the same issue. I have now found a work-around which means I don't have to use the Counter anymore...

J
Forum|alt.badge.img

Hi,

 

I'm having almost the same issue. When counting the result from sql executor it returns whats seen in the inspector, but counter works fine for the initiator.

What was your solution @aquamarine ?

Thanks in advance

 

ebygomm
Influencer
Forum|alt.badge.img+44
  • ebygommInfluencer
  • Influencer
  • 3427 replies
  • February 4, 2020

Hi,

 

I'm having almost the same issue. When counting the result from sql executor it returns whats seen in the inspector, but counter works fine for the initiator.

What was your solution @aquamarine ?

Thanks in advance

 

I wonder if this is related to the bulk mode issue that was affecting the statistics calculator

https://knowledge.safe.com/questions/102959/incorrect-results-from-statisticscalculators-cumul.html

If you put a python caller in front of it (doing nothing) does it fix it?

fmelizard
Safer
Forum|alt.badge.img+20
  • fmelizardSafer
  • Safer
  • 3719 replies
  • February 4, 2020

Hi,

 

I'm having almost the same issue. When counting the result from sql executor it returns whats seen in the inspector, but counter works fine for the initiator.

What was your solution @aquamarine ?

Thanks in advance

 

Hi @jonathanklarup Try a PythonCaller as @ebygomm suggested, or an Offsetter, or an AttributeKeeper - all of these are transformers which will split up the feature tables. See the explanation here: https://knowledge.safe.com/questions/105599/why-is-my-counter-transformer-giving-me-a-weird-va.html

J
Forum|alt.badge.img

Hi @jonathanklarup Try a PythonCaller as @ebygomm suggested, or an Offsetter, or an AttributeKeeper - all of these are transformers which will split up the feature tables. See the explanation here: https://knowledge.safe.com/questions/105599/why-is-my-counter-transformer-giving-me-a-weird-va.html

worked like a charm, thank you @danatsafe

Community Stats

32,078
Posts
121,802
Replies
39,707
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.