Problems when comparing two tables containing same fields

[#1]

Hi,

Really hope you can help me.

I have two tables containing exactly the same fields, but are in different databases. I would like to compare them.

I have heard, there is a function where you can insert the table name in front of each field so they become unique.

Can you help me with the function and how to use it?

Your help will be very much appreciated!

[Gysbert_Wassenaar · Accepted solution]

That function is called Qualify. Use it with care.

Qualify * ;

TableX:
LOAD *
FROM ... ;

[qlikviewwizard]

Hi,

Please check these threads.

Do you Qualify?- How to use QUALIFY statement

Scenarios for Qualify

qualify and unqualify