topic Re: Generic et (Un)Generic in QlikView

Generic et (Un)Generic

Thu, 18 Jul 2013 19:37:28 GMT

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

Re: Generic et (Un)Generic

hic — Thu, 18 Jul 2013 20:14:36 GMT

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

Re: Generic et (Un)Generic

Thu, 18 Jul 2013 20:44:20 GMT

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.

Re: Generic et (Un)Generic

Thu, 18 Jul 2013 20:56:56 GMT

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?

Re: Generic et (Un)Generic

hic — Thu, 18 Jul 2013 21:24:09 GMT

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

HIC

Re: Generic et (Un)Generic

Fri, 19 Jul 2013 13:05:49 GMT

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