topic Re: Matching in QlikView

Matching

Anonymous — Thu, 14 Sep 2017 06:14:27 GMT

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

Re: Matching

Anil_Babu_Samineni — Thu, 14 Sep 2017 06:17:08 GMT

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

Re: Matching

its_anandrjs — Thu, 14 Sep 2017 06:19:49 GMT

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

Resident Source;

Concatenate(New)

Load

b as a

Rssident Source;

Re: Matching

its_anandrjs — Thu, 14 Sep 2017 06:20:51 GMT

My Bad please delete the main table also

Source:

Load * inline

[

a, b

1, 5

2, 6

3, 7

4, 8

];

Noconcatenate

New:

Load

Resident Source;

Concatenate(New)

Load

b as a

Resident Source;

Drop table Source;

Re: Matching

vardhancse — Thu, 14 Sep 2017 06:28:57 GMT

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;