Skip to main content
Question

Creating a Network Using 'From' and 'To' Columns with Specific Conditions


parashari
Forum|alt.badge.img+2

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.

2 replies

daveatsafe
Safer
Forum|alt.badge.img+19
  • Safer
  • June 5, 2023

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


parashari
Forum|alt.badge.img+2
  • Author
  • June 6, 2023
daveatsafe wrote:

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


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