Turning Fields into records "pivoting" - Help!

[Gisle]

Hey!

I have a database with seven fields with one possible fixed value in a Valuelist. the reason for this is that it works well on a layout in web companion with checkboxes, and alows checking, unchecking etc on the web. The record look like this:

ID value A value B value C etc

1 A C

2 B

3 B C

My problem is I now have the need to use these values in portals and for export so i need to make a new file with record that look like this:

ID value

1 A

1 C

2 B

3 B

3 C

I dont want blank entries. As you can se i can now view these in a portal based on a relationship. In a spreadsheet this conversion process would be called pivoting i think?

Can i make a script to traverse the whole file writing new values to another file based on if statements?

I have tried but cant figure it out. Should the script stay in the new or old file? Do I need a relation between the files?

Please help!

[dbruggmann]

You can. First you have to find in the first file all records, which are not empty: Do this for every value field separately and export then the fields