Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
jjustingkm
Contributor III
Contributor III

Union vs Concatenate

Just wanted to know if there is any difference between union in oracle and concatenate in qlik sense.

1 Solution

Accepted Solutions
MayilVahanan

HI @jjustingkm

In General, both are same concept.

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/Scrip...

In Qlikview, we don't want to create any dummy column to make both table has same column. It will generate null values automatically. 

And also, if all columns are same in both table & u don't want to merge together, then "No Concatenate" concept helps in Qlik.

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/LoadData/concat...

 

Thanks & Regards,
Mayil Vahanan R

View solution in original post

3 Replies
joaopaulo_delco
Partner
Partner

Hi @jjustingkm !

        There some differences between union in oracle and concatenate in qlik sense.

- I think the main difference is that in oracle union you must have the same collumns in the two queryes. The qlik sense concatenate you can do it even not have any collumns in common.

jjustingkm
Contributor III
Contributor III
Author

thats true, but in oracle you can create dummy column to to make both sqls in sync.

MayilVahanan

HI @jjustingkm

In General, both are same concept.

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/Scrip...

In Qlikview, we don't want to create any dummy column to make both table has same column. It will generate null values automatically. 

And also, if all columns are same in both table & u don't want to merge together, then "No Concatenate" concept helps in Qlik.

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/LoadData/concat...

 

Thanks & Regards,
Mayil Vahanan R

View solution in original post