Table transform on Script

[#1]

I've this table:

ID|FIELD_1        |FIELD_2   |FIELD_3

1 |SOLTEIRO     |FEMININO        |NAO

2 |SOLTEIRO     |FEMININO        |SIM

3 |CASADO        |MASCULINO    |SIM

And i need transform this table in (on script time):

FIELD_XX          |VALUE

FIELD_1             |SOLTEIRO

FIELD_1             |SOLTEIRO

FIELD_1             |CASADO

.

.

and so on.

Someone have idea?     

Thanks

[swuehl · Accepted solution]

So you want to transform your crosstable into a straigh table, right?

Try a CROSSTABLE load prefix:

Crosstable (FIELD_XX, VALUE) Load * from ...;

[#3]

Thank´s Swuehl.

It Works fine.

Sds