Fill Cross Table

[cristian_av]

Hi

I have data with the following format:

Role           User

Admin        User1

Admin        User2

Admin        User3

Role2        User2

....

And I need to create a Table like this:

Wich expression should I use in my table?

I've tried with "=1", but it puts a 1 in all the records, so it's useless.

Thanks!!

[marcus_sommer · Accepted solution]

Try it with: count(User)

- Marcus

[german24]

Hi,

try this...

Best regards,

German

[el_aprendiz111]

Hi,

DATA:
LOAD *, 1 AS COUNT;
LOAD * Inline
[
Role,User
Admin,User1
Admin,User2
Admin,User3
Role2,User2
];
EXIT Script;