Skip to main content
  • EN

Dear Safers,

I am trying to create this network using the 'From' and 'To' columns.

So, the number in 'From' is connected to 'To', and then find this 'To' number in 'From' and find it's corresponding 'To', and again find the second 'To' in next 'From' and get it's corresponding value in 'To'.

The catch is, the value in 'To' has to be greater than 'From'.ExampleI can think of a go to solution in SQL, but can't think of something using transformers.

Thank you for the support.

Hi @parashari​,

Try using a Tester with the following settings, then using the Failed output. This will filter out all the Lines where the To is smaller than the From.

Screen Shot 2023-06-05 at 2.48.02 PM

Hi @parashari​,

Try using a Tester with the following settings, then using the Failed output. This will filter out all the Lines where the To is smaller than the From.

Screen Shot 2023-06-05 at 2.48.02 PM

That was a quick one, Thank you @daveatsafe​.

Can I also create a network like the below one?

Thank you.Output

Reply


Community Stats

30,162
Posts
114,483
Replies
37,809
Members
Terms & ConditionsCookie 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.