Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
So you want to transform your crosstable into a straigh table, right?
Try a CROSSTABLE load prefix:
Crosstable (FIELD_XX, VALUE) Load * from ...;
So you want to transform your crosstable into a straigh table, right?
Try a CROSSTABLE load prefix:
Crosstable (FIELD_XX, VALUE) Load * from ...;
Thank´s Swuehl.
It Works fine.
Sds