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
