Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Generic et (Un)Generic

Hi guys,

I work on genericity.

Is there a mean to get a table generic? The word Generic is able to ready a generic table ans specify it but I'm looking for the opposite: the ungeneric function.

It's the same functionnality than Unpivot on MS.

If you have got some ideas or experience about that.... please let me know.

Thansk by advance,

Eva

1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

The Crosstable prefix is in principle the opposite of the Generic prefix. The Crosstable can be used to fold a large number of columns into two columns. For example, if you have one column per month, you can use the crosstable prefix to get one column with month name and a second with month value.

HIC

View solution in original post

5 Replies
hic
Former Employee
Former Employee

The Crosstable prefix is in principle the opposite of the Generic prefix. The Crosstable can be used to fold a large number of columns into two columns. For example, if you have one column per month, you can use the crosstable prefix to get one column with month name and a second with month value.

HIC

Not applicable
Author

But when I do a crosstable on a classic table I don't get a generic one :S

The objective is getting a generic table in output (qvd, xls...) from a normal table.

:S

Not applicable
Author

Ok, It's works if I generate an ID with RowNum !!! \o/\o/\o/\o/\o/

Thanks a lot for your help.

I have another question about that. Did you already see a generic full  loading flow? Do you think it's possible or there is some limitations?

hic
Former Employee
Former Employee

Not sure what you mean with "generic full  loading flow". Can you give an example or post some data that needs converting?

HIC

Not applicable
Author

I work on genericity and MOF. I will try to do a load in generic see if it's working, and let you know if I did it.

The target is generate the loading statements in a dynamic way.

Thanks a lot for you help