topic Combine multiple fields into one common field in QlikView

Combine multiple fields into one common field

b_garside — Mon, 08 Dec 2014 18:22:44 GMT

I have several Race fields that should be combined into one common field since they have a common attributes.

The problem is how do I combine the Six fields when they have a Y/N value for each one and map it to the label of the fields?

Current Schema:

its_anandrjs — Mon, 08 Dec 2014 18:33:58 GMT

Hi,

Please explain the field names or you can use subfield here

This data in which two fields

Current Schema:

Regards

Anand

b_garside — Mon, 08 Dec 2014 18:59:04 GMT

If I have 6 fields that have 6 Y/N values I want to convert them into one field that has the descriptions instead.

I can create a mapping table as well to help.

Would like the data to be stored like this.

its_anandrjs — Mon, 08 Dec 2014 21:19:41 GMT

Can you explain with table structure that will be great.

Regards

Anand

prieper — Mon, 08 Dec 2014 21:33:51 GMT

You may use a crosstable-approach, but with this limited amount of criteria, would go with a plain approach:

Data:

LOAD

Attrib1,

Attrib2,

IF(IsWhite = 'y', 'White') & IF(IsBlack = 'y', 'Black') & IF(IsIndian = 'y', 'Indian') AS Race

INLINE [Attrib1, Attrib2, IsWhite, IsBlack, IsIndian

a, aa, y, n, n

b, bb, y, n, n

c, cc, n, y, n

d, dd, n, n, y];

HTH Peter