Skip to main content
Solved

How to filter the last returned row


oliver.morris
Contributor
Forum|alt.badge.img+12

I am essentially looping through httpcaller results and need a way to pass a value from the last record returned in a loop, I dont know how many records will be returned. I was using the stats calc to get the max value but that is blocking the loop from running within the one workbench. Does anyone have any suggestions, thank you

Best answer by jdh

To use blocking transformers in a loop, you need to have a linked rather than embedded custom transformer. The loop input will also have to be published (really annoying, I generally call it LoopInputDoNotUse)

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

5 replies

oliver.morris
Contributor
Forum|alt.badge.img+12
  • Author
  • Contributor
  • July 16, 2021

hkingsbury
Celebrity
Forum|alt.badge.img+53
  • Celebrity
  • July 18, 2021
oliver.morris wrote:

Use the sampler with it set to "Last N Features"


oliver.morris
Contributor
Forum|alt.badge.img+12
  • Author
  • Contributor
  • July 19, 2021
hkingsbury wrote:

Use the sampler with it set to "Last N Features"

thanks but unfortunately I get - Input Splitter (BranchingFactory): Transformer/Factory GetMembers_Sampler is blocking and cannot be used in a loop, but was found between... so the sampler is a blocking transformer for this loop as well.


jdh
Contributor
Forum|alt.badge.img+28
  • Contributor
  • Best Answer
  • July 19, 2021

To use blocking transformers in a loop, you need to have a linked rather than embedded custom transformer. The loop input will also have to be published (really annoying, I generally call it LoopInputDoNotUse)


oliver.morris
Contributor
Forum|alt.badge.img+12
  • Author
  • Contributor
  • July 20, 2021
jdh wrote:

To use blocking transformers in a loop, you need to have a linked rather than embedded custom transformer. The loop input will also have to be published (really annoying, I generally call it LoopInputDoNotUse)

thanks, I went down this route as I dont think it is possible without blocking transformers.


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