Concatenate two tables

[#1]

Hi,

I have a table with 3028 rows and 65 columns (fields).

For some reason I need to load 3028 rows and 4 columns first, and then, add the same for the other 61 columns so at the end I need to have the original table (3028 x 65) loaded.

I tried JOIN LOAD and it multiplies the resulting rows in millions, I tried CONCATENATE it multiplies the resulting rows by 2, ...

I think must exist a simple command to do that simple task.

Thanks.

[kumarnatarajan · Accepted solution]

Hi,

It is fact one. you will try to left join with some Mapping(Unique) fields.

[#3]

use LEFT KEEP

or try with WHERE condition

[sushil353]

Hi,

Try this sample:

tab1:

load *,RecNo() as flag inline [

Name,Amount

John,-22

John,10

John,12

Mike,-10

Mike,5

];

join(tab1)

load *,recno() as flag Inline

[

test

a

b

c

f

g

];

put an extra field called flag in both load with function recno().

HTH

Sushil

[#5]

Unfortunately there is no mapping fields, the question is as simple as paste a table previously cutted in two:

[kumarnatarajan]

Hi,

See the sushil kumar syntex:

T1:

Load *,RowNo() as Key from T1File;

left join(T2)

Load *,RowNo() as Key from T2File;

Now RowNo() as Key this is mapping field. So now it is possible

[sushil353]

could you provide some sample data.. say first 5 field and then 4-5 additional field..

[#8]

It is allready solve, it was a question of using some common fields and an ordinary join load.

Thank you