Crosstable using a load resident

[#1]

Hi all

I need to do a crosstable on a table that I already have in my app. Is it possible to do so using a load resident? If not, how should I do it?

[MindaugasBacius · Accepted solution]

You can do this:

Table:
Load *
Inline [
ID, 2016-01-01, 2016-01-02
1, A, 
2, B, C
3, , D
];


Table2:
CrossTable(Date, Data)
LOAD ID as Iden, 
     [2016-01-01], 
     [2016-01-02]
Resident Table;

And the result would be like: