Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Table transform on Script

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

1 Solution

Accepted Solutions
MVP
MVP

Table transform on Script

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

Try a CROSSTABLE load prefix:

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

2 Replies
MVP
MVP

Table transform on Script

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

Try a CROSSTABLE load prefix:

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

Not applicable

Table transform on Script

Thank´s Swuehl.

It Works fine.

Sds

Community Browser