topic Combining 2 straight table into one in QlikView

Combining 2 straight table into one

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Class:

LOAD * INLINE [

Student, Birth Country, Nationality, Score

Marco, French, Italian, 100

John, British, Italian, 90

David, German, British, 80

Matthew, French, German, 70

Yan, British, Spanish, 60

Mark, German, Austrian, 50

];

I would like to display in straight table the combination of both:

and

One straight table only, Any idea if at all possible?

Many thanks

Raphael

Anil_Babu_Samineni — Wed, 18 Oct 2017 12:38:22 GMT

What if we RENAME the field into common one.

sunny_talwar — Wed, 18 Oct 2017 12:52:14 GMT

Like this?

Anonymous — Wed, 18 Oct 2017 13:06:54 GMT

As always Sunny you are a shining star, many thanks