topic Re: Is possible to JOIN a sql table with a QVD file? in App Development

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

VijaySekar — Tue, 25 Jul 2023 13:52:20 GMT

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

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

Or — Tue, 25 Jul 2023 13:56:37 GMT

Same as you would join any two Load statements.

Load * From SomeQVD;

JOIN

Load *;

Select * From SomeTable;

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

VijaySekar — Tue, 25 Jul 2023 14:20:20 GMT

How should i mention the join condition?

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

Or — Tue, 25 Jul 2023 16:01:34 GMT

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.

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

VijaySekar — Tue, 25 Jul 2023 16:51:32 GMT

What happens if we have 3 identical columns?

Which column will it take?

Thanks

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

Or — Wed, 26 Jul 2023 09:48:58 GMT

All of them.

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