Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Partner
Partner

Field name in the same column

Hello, I need help with changing data structure. As in the image

Dimension.jpg

The dimension of this field name as "Name" and it has 4 attributes as "A, B, C, D" I would like to change A, B, C, D as a fields (dimension). How can I do it? I try "Unpivot"but it split this field into 2 fields as "Event" that contain all attribute as 'Name' in it and "Event" that contain 'A, B, C, D' in it.

2 Replies
Partner
Partner

Re: Field name in the same column

What values do you expect to have in the fields A, B, C and D?

Re: Field name in the same column

If you are working using "Data Manager" There you can use "Unpivot" concept. If you are using Data Model viewer - Use, Generic Load concept Or Use Cross Table concept

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)