Is possible to JOIN a sql table with a QVD file?

[VijaySekar]

I have a sql table and i need to do a left join with a QVD file based on a key column. Is it possible? If so can anyone guide me on this please?

Thanks

[Or]

Same as you would join any two Load statements.

Load * From SomeQVD;

JOIN

Load *;

Select * From SomeTable;

[VijaySekar]

How should i mention the join condition?

[Or]

There is no join condition. Joins are automatically based on fields with identical names (case-sensitive). Again, this is true for all Qlik joins regardless of source.

[VijaySekar]

What happens if we have 3 identical columns?

Which column will it take?

Thanks

[Or · Accepted solution]

All of them.

https://help.qlik.com/en-US/sense/May2023/Subsystems/Hub/Content/Sense_Hub/Scripting/combine-tables-...