topic Table transform on Script in QlikView

Table transform on Script

Mon, 12 Dec 2011 00:01:31 GMT

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 |CASADO

and so on.

Someone have idea?

Thanks

swuehl — Mon, 12 Dec 2011 00:11:16 GMT

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

Try a CROSSTABLE load prefix:

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

Mon, 12 Dec 2011 10:33:15 GMT

Thank´s Swuehl.

It Works fine.

Sds