insert values in a excel table

[#1]

Hello together,

new day new Problem.

I want to load the first table with

LOAD

Product;

€

Product	€
A	3
B	5

how can i insert a new rows

Product	€
C	7
D	8

to the original table. It should Display the following table.

Product	€
A	3
B	5
C	7
D	8

What LOAD Statement I Need for this requirement

Thanks

Jörn

[giakoum]

where do those new rows come from? Or should always the same row be added?

[jerem1234]

Maybe the Concatenate keyword would be of use?

Concatenate(Table1)

Load

....

Hope this helps!

[#4]

the new rows come from a formula which calculated the rows with sum function.

The Product C is a Sum formula and the Product D also.

[giakoum]

then the solution suggested by jeremiah is what you need.

concatenate(Table1)

load

     Category

     sum(€) as €

resident Table 1

group by

     Category

or similar...