Create Crosstable with resident table

[#1]

Hallo,

is it possible to create a crosstable using a resident table?

Little example:

This format :

Serial	Date
S1	11-05-2013
S2	03-05-2013
S1	07-02-2013
S1	11-05-2013
S3	10-05-2013
S2	09-05-2013
S3	01-05-2013

to this one:

Serial	01-05-2013	02-05-2013	03-05-2013	04-05-2013	05-05-2013	06-05-2013	07-05-2013	08-05-2013	09-05-2013	10-05-2013	11-05-2013
S1							1				2
S2			1						1
S3	1									1

?

You didn't have to explain it, if there is an other post wich does so...

But i cant find anything about and would also be happy if u give me the link to this post:)

And there is no use in defining every column, because in the end the time interval will be over several years.

And i dont want to define more than 365 days^^

Thx

Sarah

[Gysbert_Wassenaar]

If you really want to cripple your data model you can use Generic load. See the help file for details.

Data:

Generic

LOAD *, 1 as Counter INLINE [

    Serial, Date

    S1, 11-05-2013

    S2, 03-05-2013

    S1, 07-02-2013

    S1, 11-05-2013

    S3, 10-05-2013

    S2, 09-05-2013

    S3, 01-05-2013

];

Otherwise leave the data as it is and use a pivot table to show the data as a crosstable.

[#3]

XD to cripple it^^

I suspected that answear;)

Thank u anyway:)

But i have to define every date?

There's no possibility to cripple it automatically, mean any QV function?

And yes, if i can i try to avoid using this. But i have some "self animated" charts using crosstables and i dont want to create them with Excel any longer:/

This will only be used for some special chart, where i didn't find a solution to avoid using crosstables.

[Gysbert_Wassenaar]

The inline is just an example, you can use a resident load instead. See attached example. It has a pivot table based on the original data format and two straight tables using the exploded data from the Generic load. My advise is to not do a generic load and use the pivot table instead to show the data in that layout.

[#5]

How would the statement look, if i use resident?