Matching

[Anonymous]

a	b
1	5
2	6
3	7
4	8

This is my data but I want output like two fileds are comes in one field  like

c

1

2

3

4

5

6

7

8

[Anil_Babu_Samineni]

May be load 2 times one for a and one more for b then replace it to c from a and c from b then JOIN each

[its_anandrjs]

You have to load this table two times then and make same field names

Source:

Load * inline

[

a, b

1, 5

2, 6

3, 7

4, 8

];

Noconcatenate

New:

Load

a

Resident Source;

Concatenate(New)

Load

b as a

Rssident Source;

[its_anandrjs]

My Bad please delete the main table also

Source:

Load * inline

[

a, b

1, 5

2, 6

3, 7

4, 8

];

Noconcatenate

New:

Load

a

Resident Source;

Concatenate(New)

Load

b as a

Resident Source;

Drop table Source;

[vardhancse]

Hi Can try,

Table_Temp:

LOAD * INLINE [

    a, b

    1, 5

    2, 6

    3, 7

    4, 8

];

Table:

LOAD a as c

Resident Table_Temp;

LOAD b as c

Resident Table_Temp;

Drop Table Table_Temp;