Merge files in load editor

[robin_heijt]

Hi,

I currently have 3 data sources,

1: (Name, Line Manager, Line manager-1, DOB, Age, Age Grp)

2: (OPR 2017)

3: (OPR 2018)

Now 1 merges fine with 2 and 3 separately, but 2 and 3 still distinct themselves.

Due to this, every person shows up twice, once with OPR 2017 and once with OPR 2018

What syntax would I have to use to combine the 2 of these into one row within the Data Load Editor.

I know that it is possible in an expression, but I specifically need it for the data load editor.

Thanks.

[robin_heijt]

Thank you for your response, you are being very helpful. However I am a little unsure as what you are trying to explain.

This is part of my first data source:

// General Load Script

LOAD

    "Global ID",

    "Personnel Number",

    Capitalize("First name"&' '& "Last name") as "Full Name",

    "Employment Status Text" as "Employment Status",

    "Employee group",

    "Name of employee grp" as "Employee Group"

FROM [lib://AttachedFiles/1Europe.xlsx]

(ooxml, embedded labels, table is Headcount);

// OPR 2017

load *, keepchar("Last Published OPR Rating 2017",'4A4B3A3B21A1B') as "OPR 2017";

LOAD

    "Employee Global ID" as "Global ID",

    Capitalize(Name) as "Full Name",

//    "Position Title of Record",

//    "Summary Competency Rating - Numeric Value",

//    "Summary Competency Rating - Scale Value",

//    "Preliminary OPR Rating",

    "Last Published OPR Rating" as "Last Published OPR Rating 2017"

//    "Year",

//    "Plan Name",

//    "Review Period Start Date",

//    "Review Period End Date",

//      "Final Evaluation Workflow State"

FROM [lib://AttachedFiles/OPR 2017.xlsx]

(ooxml, embedded labels, table is [OPR 2017]);

General names:

as a sample list (5 names out of 15.000)

Global ID - Full Name - etc..

1 - Harry

2 - Jack

3 - Dina

4 - Maria

5 - Sanne

19 - Jord

OPR 2017 names:

Global ID - Full name - OPR 2017 - etc...

1 - Harry - 4

2 - Jack - 3

3 - Dina - 4

4 - Maria - 5

14 - Dirk - 3

17 - Jenny - 2

19 - Jord - Blank

So I would want the list to show only the names from the general script:

1 - Harry - 4

2 - Jack - 3

3 - Dina - 4

4 - Maria - 5

5 - Sanne - "No Score" (If no result in OPR 2017 fill "No Score")

19 - Jord - "No Score" (If blank OPR Score fill "No Score")

I would really appreciate if you can help me out with this situation!

Thank you.

[Anonymous]

Create another question for this, in this way it can help others with the same problem. 

But in resume, you need to make a field on the general table colecting the names and putting inside a unique column name. In that way you will be able to filter if the name contains in this column.

Sorry if i am not being clear enough. Create another question so that we can help others, i will try my best with a complete answer. 

Something like this. 

Load

Name as uniqueName,

[rest of the code] 

[robin_heijt]

Thank you again for being so helpful.

I have created a new thread.