Jump to content

Loopy Loops


This topic is 7361 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have two protals Portal 1 and portal 2 linked to a file. In portal 1 I have the values a, b, c, d and in portal 2 I have the values 1, 2, 3, 4 I need to combine these portals in another file so that I will have a 1, b 1, c 1, d 1, a 2, b 2, c 2, d 2,.....

I cannot hink of a way to both sources of data for this.

In the main display I have a job number which allows me to link the 2 files. Can anyone help my brain is now fried with attempts.

Simon

Link to comment
Share on other sites

What you need here is a looping script with two nested loops.

# Set row counter 1 to first row

# Set row counter 2 to first row

Loop

# Select a row in portal 1

Loop

# Select a row in portal 2

# Combine values and write a record to third file

# Exit Loop if last row

# Set row counter(2) to row counter(2) + 1

End Loop

# Exit Loop if last row

# Set row couner(1) to row counter(1) + 1

End Loop

You could also do this using the found sets in the two files and skip the need to be on the layout with two portals for the script to work. You will have to use a Go to field step before the Go to portal row step to tell FM which portal you mean.

-bd

Link to comment
Share on other sites

This topic is 7361 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.