Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have one table that I am trying to concatenate to itself basically with just one additional manually defined field. Here is the table structure:
Table1:
LOAD MonthNum,
Account,
Cost,
'2016' AS Year
FROM
(ooxml, embedded labels, table is Sheet1);
I then want to add data from another file (Table2.xlsx) that has the same fields except for the Year. What is the best way to do this? I would like to use a QVD if possible.
Hi Cliff,
You can use either Join command or Concatenate:
Table1:
LOAD MonthNum,
Account,
Cost,
'2016' AS Year
FROM
(ooxml, embedded labels, table is Sheet1);
Store Table1 into Table1.qvd();
Join(Table1)
Load *
FROM
[Table1.qvd]
(qvd)
Join(Table1)
LOAD MonthNum,
Account,
Cost
FROM
(ooxml, embedded labels, table is Sheet1);
Hi Cliff,
You can use either Join command or Concatenate:
Table1:
LOAD MonthNum,
Account,
Cost,
'2016' AS Year
FROM
(ooxml, embedded labels, table is Sheet1);
Store Table1 into Table1.qvd();
Join(Table1)
Load *
FROM
[Table1.qvd]
(qvd)
Join(Table1)
LOAD MonthNum,
Account,
Cost
FROM
(ooxml, embedded labels, table is Sheet1);
You can add the Table2 rows to Table1 using a concatenate
concatenate (Table1)
LOAD MonthNum,
Account,
Cost
FROM
(ooxml, embedded labels, table is Sheet1);