how can i concatenate but still leave tables just in case i need them

[Anonymous]

Hi,

i want to concatenate two tables into a separate table.  I.e. i have three tables in the end.

cheers,

Laura

[SreeniJD]

For keeping the tables, use "Keep" function. This will keep your tables and still performs Join.

HTH

Sreeni

[SreeniJD]

Refer this document.. its very well written!

Understanding Join, Keep and Concatenate

[datanibbler]

Hi Laura,

then you just have to make several steps:

- First you load one table;

- Then you parse it in a loop over the Fieldname() function and rename every field, with a > _A < or something;

- Then you load the second table;

- Then you do the same renaming with a different suffix to this one.

- Then you just make a copy of the first table with the NOCONCATENATE option;

- You parse it again and rename every field in the copy;

- Make a copy of the second table with NOCONCATENATE;

- Rename all the fields so it matches the fieldnames of the first one and will now be concatenated.

HTH

Best regards,

DataNibbler

[santhosh_k_n]

Hi Laura,

Please follow the steps to achive this,

1. load the two tables into one table by concatinating.

2. using Qualify and Unqualify functions load the tables individually again.

by doing so you can have all the 3 tables.

BR,

S.K.