Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

darroyo_telcomu
New Contributor III

Sense3 - Load 2 excel with the same columns

Good afternoon,

perhaps it is a simple matter but I'm not finding the solution. I have two Excel files with the same columns. I'm trying to load both files with "concatenate" in order to get one only table with records of both files, but instead I get the two tables separately and a third one with synthetic key that includes all fields.

This is the code:

Dedications:

LOAD

    "Date"

    "Date / Time"

    Project,

    "Project Category"

    Company,

    Who,

    "Hours"

    minutes,

    "Decimal Hours"

    description,

    "Task List"

    Task,

    "Parent Task"

    "Is Sub-task"

    "Is it Billable?"

    "Invoice Number"

    "Tags"

FROM [lib: //AttachedFiles/teamwork.xlsx]

(OOXML, embedded labels, table is Overview);

Concatenate (DEDICATIONS)

LOAD

    "Date"

    "Date / Time"

    Project,

    "Project Category"

    Company,

    Who,

    "Hours"

    minutes,

    "Decimal Hours"

    description,

    "Task List"

    Task,

    "Parent Task"

    "Is Sub-task"

    "Is it Billable?"

    "Invoice Number"

    "Tags"

FROM [lib: //AttachedFiles/inplants.xlsx]

  (OOXML, embedded labels, table is Inplants);

6 Replies
Khan_Mohammed
Honored Contributor II

Re: Sense3 - Load 2 excel with the same columns

Have you tired Outer Join instead of Concatenate? It would be more helpful if you can upload a .qvf related to this issue.

Thanks.

darroyo_telcomu
New Contributor III

Re: Sense3 - Load 2 excel with the same columns

Hello,

Outer Join doesn't work too, and I think I should use Concatenate because I want records of second table added to records of first table. Sorry but I can't upload qvf of this application.

Just one question, Does Concatenate works with Excel in the same way it works with database tables?

fredericmante
New Contributor III

Re: Sense3 - Load 2 excel with the same columns

Caution case sensitive in the names of tables:

Concatenate (DEDICATIONS)

fredericmante
New Contributor III

Re: Sense3 - Load 2 excel with the same columns

Another idea.

Try without instruction Concatenate

darroyo_telcomu
New Contributor III

Re: Sense3 - Load 2 excel with the same columns

Thank you Frédéric, but it still creates that third synthetic key table. Maybe I have a concept error about attaching Excels in the connection section and the load script. I'm going to review my work and I will write any news here.

darroyo_telcomu
New Contributor III

Re: Sense3 - Load 2 excel with the same columns

Hello, I finally have found the error on my script. I didn't see the "automatic generated section" when importing Excels. That section was importing the information, and I was importing the information again with a new load script in the main section.

Hope this helps to other beginners.

Best regards,

David.

Community Browser