From columns in diffrent tabels to one column in one tabel

[#1]

Hi!

I have 4 tabels, one main with a columnn X that I want to populate from 3 diffrent tabels depending on if other columns have values in them and the tabels have diffrent priorities.

First i X populated from Hight_Car, Hight matching columt A in main, next vaules from Textures are added and after that Colors and because Colors have higher priorites the row 2 column X changes to MB .

So the main tabel looks like this.

Ex

Main tabel

A	Color	Texture	Hight	E	F	X
1	Blue		Low			Volvo
2	Gray	Hard				MB
3	Green		High			Porsche
4	Red	Soft				MB

Color_Car Prio 1

A	B
Blue	Volvo
Gray	MB
Green	Porsche

Texture_Car Prio 2

A	B	C
Soft	MB

Hight_Car Prio 3

A	B
High	Saab

Is this posible to do in Qlikview?

Regards

Otto

[#2]

Hi Otto,

two steps to get the result

a) fetch the data into three fields called Prio1, Prio2, Prio3

b) melt these three into one field called X, depending on the values of Prio1 to Prio3

See attached qvw for details.

Roland