Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Matching

   

ab
15
26
37
48

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

4 Replies
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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
its_anandrjs
Champion III
Champion III

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
Champion III
Champion III

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
Specialist III
Specialist III

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;