Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 <>;
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