Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Combining 2 straight table into one

1.png

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:

1.pngand

1.png

so

1.png

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

Many thanks

Raphael

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

3 Replies
Anil_Babu_Samineni

What if we RENAME the field into common one.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sunny_talwar

Like this?

Capture.PNG

Anonymous
Not applicable
Author

As always Sunny you are a shining star, many thanks