Merge two fields data into one field

[profilejamesbond]

Hi,

I want to merge two fields data into one field. Such as shown in the given below table examples. I have Key, and now I want to merge Dimension_A and Dimension_B data into Dimension_A. So, finally, I must have Dimension_A including Dimension_B data

Table1:

Key

Dimension_A

Table2:

Key

Dimension_B

Thanks

[henrikalmen]

It is not quite clear if you want to have values from Dimension_A and Dimension_B in the same field or what you want, but perhaps you could do something like this:

tmp: load Key, Dimension_A from [data1];
join(tmp) load Key, Dimension_B from [data2];

Table1: load Key, Dimension_A&DimensionB as merged_field resident tmp;

[anat]

Table1:
load * inline [
key,dimA
1,a
2,b
];
concatenate(Table1)
load key,dimB as dimA;
load * inline [
key,dimB
3,c
4,d
];