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);
