Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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

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