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;
