Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

balasundaram
Contributor II

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

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

2 Replies
MVP
MVP

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

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 <>;

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

Hi,

one solution could be:

QlikCommunity_Thread_134136_Pic1.JPG.jpg

CrossTable (X, C)

LOAD 1, *

INLINE [

    A, B

    1, 2

    3, 4

];

DROP Fields "1", X;

hope this helps

regards

Marco

Community Browser