Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need rows from one table not required from another table

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;

1 Reply
Not applicable
Author

Attached sample files. A, B and expected output.