Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
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?
Not sure what you mean with "generic full loading flow". Can you give an example or post some data that needs converting?
HIC
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