Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
swuehl
MVP
MVP

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

Try a CROSSTABLE load prefix:

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

View solution in original post

2 Replies
swuehl
MVP
MVP

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
Author

Thank´s Swuehl.

It Works fine.

Sds