Qlik Community

Third-Party Qlik Jobs

Area for people to learn more about current Qlik related job postings.

Not applicable

How to get Not equal value from two flatfile?

I have two flat file and it contain common one column values is equal to two flat file. so normally we using inner join and retrieve data, but here my scenario not equal to be display in the report?. If anyone known this answer help to me.

2 Replies

Re: How to get Not equal value from two flatfile?

Use

Where Exists(ID)

Considering that you have ID field common.

Re: How to get Not equal value from two flatfile?

Table1:

Load * Inline

[

  ID, Sales

  A, 100

  B, 200

  C, 220

];

Table2:

Load * Inline

[

  ID, Cost

  A, 80

  B, 175

  C, 200

  D, 300

  E, 400

]

Where Exists (ID);