Extracting portal rows to separate fields

[Jaded]

Hi,

After a day of fruitless hunting I'm finally posting!

I have two tables. Each has a tracking_usr field. In table_1 this is unique. In the table_2 there are up to 5 instances of the tracking_usr, i.e. up to 5 records with it, each with a different tracking_options field.

I want to create 5 extra fields in table_1, then take the tracking_options data for each tracking_usr in table_2 and place it into the appropriate extra field. I can get a portal to work and the data shows up lovely on screen, but I need to be able to export this data to Excel in separate columns.

I thought (having used FM since V1) that I knew what I was doing....

[-Queue-]

Can you post a stripped-down version of your file? I'm fairly certain we can accomplish this using some calculations, if we can see what the structure is.

[Jaded]

Ok, here is the file - with (hopefully) any sensitive data removed.

The database collects data from a mySQL database - I then need to export it to a file for someone else, in an Excel format.

Many thanks for your offer of help

trackingCopyfp7.zip

[-Queue-]

I added a value list based on the related items and changed the Workshop # fields to parse it to pull the correct info. See modified attachment.

trackingCopy.zip

[Jaded]

That is excellent!

Thank you!

(now I need to work out how it was done - it will do me good!)

My first and only trip to California was this time of year. (Last Century though!)

Have a great afternoon.

[-Queue-]

To put it simply, ValueListItems creates a return-delimited list and each field parses through it to pick the correct line, either the first, second, third, fourth, or fifth, appropriately. Notice the only difference between each field's definition is the last parameter of the Position function, which specifies the occurence of each carriage return to use.