add row with specific vaule

[Anonymous]

Hi all,

I have a table like this:

A      B      C

1       2      3

2      2       4 

3     4        12

3     5        3

..     ..      ....

Now I just want to add row "D" with all values should be "1" for example.

Is this easily possible with ... Load ... D with "1" or something like that

Thank you for helping!

[#2 · Accepted solution]

in script write

load A, B, C,

'1' as D

FROM TABLE;

[Anonymous]

Thank you very much