I was trying to do that but something is not right. Unfortunately the field that I need to match on is a text field (person's name). One file is upper case and the other is lower case. So I tried to convert them to Upper case and then do the where exists. But I am doing something wrong.
Here is my script. I appreciate you taking a look.
Upper(mem_name) as Name,
FROM [lib://OPTIMA/June 2017 HRRJ_Extract_PHI_201706 (1).xlsx]
(ooxml, embedded labels, table is [Optima]);
Upper(Name) as Name,
// "CO days",
"Current Location Name",
(ooxml, embedded labels, table is Intake.rdl);
Where Exists (Name,Name);
//Drop Table OOCTemp;
When you load into OOCTemp you will load all the Name values, so when you load into OOC the Where Exists on it will find and load all the Name values as they all will exist.
Often with this type of scenario I would :
- Load OCDTemp
- Store OCDTemp into a qvd
- Drop OCCTemp
- Load OOC from the qvd using the Where Exists
Also for the Where Exists I'd simply use :
- Where Exists (Name)