Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Problem with MINUS

HI, I use TOS 2.1.1 - java
I?m trying for to create a minus.
There are 2 tables: A and B.
|A.NOME | B.NOME | A-B SQL |
|-----------+-----------+------------|
|(null) |MARIO | (null) | 1° case
|ROSSI | ROSSI | ________|
|A.NOME|B.NOME | A-B SQL |
|---------+---------+-----------|
|MARIO | (null) | MARIO | 2° case
|ROSSI | ROSSI | ________|
|A.NOME |B.NOME | A-B SQL |
|-----------+----------+------------|
|(null) | (null) | (empty) | 3° case
|ROSSI | ROSSI | ________|
|A.NOME|B.NOME| A-B SQL |
|---------+--------+-----------|
|ROSSI | (null) | (empty) | 4° case
| | ROSSI | _______ |
How can I have the same result using TOS?
I have tried with 2 tOracle inpmut and 1 tMap, but the results are different from SQL.
Thanks a lot 0683p000009MACn.png
Labels (2)
5 Replies
Anonymous
Not applicable
Author

The tMinus can be 'simulated' with an left outer join and a filter on the part that is not matched. Click on the inner join rejects button, on the output table.
I?ve resolved the problem reading this posts:
http://www.talendforge.org/forum/viewtopic.php?pid=3887#p3887
http://www.talendforge.org/bugs/view.php?id=424
ciao ciao 0683p000009MA9p.png
Anonymous
Not applicable
Author

With 2 tables there aren?t any problems, but with more table the results are wrongs!!
Hi, I use TOS 2.1.1 Java version,
and I try to reproduce a MINUS with 3 tables in TOS.
This is the oracle select:
select msg from log
minus
select msg from log2
minus
select cognome from paziente
I use 3 tOracleInput and 1 tMap.
I tried to 'simulated' the minus with an left outer join and a filter on the part that is not matched, but the result is wrong!!
There are my tables:
TABLE LOG
ciao
aaaa
CIAO
A1
TABLE LOG2
(null)
CIAO
CIAO2
TABLE PAZIETE
A1
(null)
rossi
The result of this MINUS in Oracle is:
-------------
ciao
aaaa
------------
Any idea?
Thanks to all 0683p000009MA9p.png
Anonymous
Not applicable
Author

Hello eng,
This MINUS problem is quite difficult to handle in TOS.
We have planned to develop all those DB functions in dedicated components.
In the interval, I think that the best thing to do is to put your request directly in your tOracleInput.
Regards,
Michaël.
Anonymous
Not applicable
Author

Hello Michaël! 0683p000009MACn.png
Thanks for answer!
I find a ?little? solution. I?ve think to split the minus in more parts.
(A-B-C) = (A-B)-C
It runs 0683p000009MA9p.png
Do you have some idea about the release plan ?
When version 2.1.2 will be released?
Thank you
Regards,
Marco
Anonymous
Not applicable
Author

2.1.2 will be released next week.
About a release with tMinus, I really can't say anything yet.
Michaël.