Table Organization

[hugojesus]

Hello,

I have a DataBase like the Table 1 loaded, and I want to create the table 2 in Qlik Sense Cloud, and I don´t know to do?

The most important in the table 2 is the columns name, the values is not important, I only want to transform the rows (DB) into columns.

I try to do this in the column´s

=FirstSortedValue(Nationality,- count(Nationality),1)

But doesn´t work...

Nationality	Department
Germany	food
Germany	restaurant
Germany	room service
France	food
France	restaurant

Table 1 - DataBase

Nationality	Germany	France
food	1	1
restaurant	1	1
room service	1	0

Table 2 - Transformation

[eduardo_dimperio]

Maybe this

crosstable (Nationality, Department) LOAD * from Table1