Append to the previous Data Structure

[ahmar811]

Hi Expert,

I have below data model and I want to add some client data just like append to the previous structure

we have to add below the table on above structure.

A	C	D	Value
789	101112	HIJ	457

Note: Here we don't have Field 'B' and also data comes base on selections

Regards

Ahmar

[petter]

You can use the CONCATENATE prefix for the LOAD statement to append data to a table that has been previously loaded in your load script. It will also accept new fields and add them.

[jobsonkjoseph]

Hi,

Do you want to append the new data into any particular table or just want to add as a separate one.

[ahmar811]

I want to append the new table into any particular table.

[jobsonkjoseph]

If to append to a particular table, then as mentioned by Petter, CONCATENATE has to be used between the tables.