How to merge two field values into single filed in one table??????

[balasundaram]

How to merge two field values into single filed in one table??????

ex:

A   B

1   2

3   4

o/p:

C

1

2

3

4

[tresesco]

Load

          A as C

From <>;

Concatenate               // would not be required if all fields are common in both the tables like in this case (C)

Load

          B as C

From <>;

[MarcoWedel]

Hi,

one solution could be:

CrossTable (X, C)
LOAD 1, *
INLINE [
    A, B
    1, 2
    3, 4
];

DROP Fields "1", X;

hope this helps

regards

Marco