Need rows from one table not required from another table

Wed, 25 Jun 2014 20:54:40 GMT

Hi,

I have two files (A&B) having same field names. I pulled those 2 files by changing field names like A_xxx and B_xxx for all fields and used a key column by combining 3 fields. Everything works well.

But I want rows only from A file, but I am getting rows from both files which I don't want

Below is the script. Can you pls suggest me how to get only records from file A. I am using few calculated fields in the expression to update few records in A file from B file.

Ex: =IF(Key=Key, City, C_City)

I am using personal edition

//TEST:

LOAD Publication as C_Publication,

Website as C_Website,

[First Name] as C_Firstname,

[Last name] as C_LastName,

Title as C_Title,

[Email address]as C_Email,

trim([First Name])&''&trim([Last name])&''&trim([Email address]) as Key,

Phone as C_Phone,

Priority as C_Priority,

[How we met] as C_How,

[Articles about us] as C_Article,

[Point of Contact] as C_POC,

City as C_City,

State as C_State,

Country as C_Country,

Target as C_Target,

Notes as C_Note

FROM

(ooxml, embedded labels, table is final);

//INNER JOIN

//TEST:

LOAD Contacted,

Publication,

Website,

[First Name],

[Last name],

Title,

[Email address],

trim([First Name])&''&trim([Last name])&''&trim([Email address]) as Key,

Phone,

Priority,

[How we met],

[Articles about us],

[Point of Contact],

City,

State,

Country,

Target,

Notes,

[Assigned to:]

FROM

(ooxml, embedded labels, table is Sheet1);

//DROP TABLE TEST;

Re: Need rows from one table not required from another table

Wed, 25 Jun 2014 21:04:42 GMT

Attached sample files. A, B and expected output.

topic Re: Need rows from one table not required from another table in QlikView

Need rows from one table not required from another table

Re: Need rows from one table not required from another table