topic Re: Merge two field into one in a table in QlikView

Merge two field into one in a table

Mon, 15 Feb 2016 14:09:57 GMT

Hello All,

I have the table below:

ABC	DEF
AP1	AP6
AP2	AP5
AP3	AP7

I need a create a table with a single field:

ABCDEF
AP1
AP2
AP3
AP5
AP6
AP7

Any idea on how I can do that?

KR,

Hasvine

Re: Merge two field into one in a table

sunny_talwar — Mon, 15 Feb 2016 14:11:32 GMT

May be this:

Table:

LOAD ABC as ABCDEF

FROM Source;

Concatenate(Table)

LOAD DEF as ABCDEF

FROM Source;

Re: Merge two field into one in a table

Mon, 15 Feb 2016 14:14:20 GMT

Does it work if both are from the same source?

Table:A

LOAD ABC,

DEF;

FROM Source;

Re: Merge two field into one in a table

sunny_talwar — Mon, 15 Feb 2016 14:15:52 GMT

I am sure it will.

Re: Merge two field into one in a table

puttemans — Mon, 15 Feb 2016 15:17:10 GMT

Hello Hasvine,

Beware, you cannot take a schortcut a script

LOAD ABC as ABCDEF,

DEF AS ABCDEF

FROM Source;

You need to follow the example from Sunny.

Re: Merge two field into one in a table

MarcoWedel — Mon, 15 Feb 2016 23:43:19 GMT

Hi,

one solution could be also:

table1:
CrossTable(temp,ABCDEF)
LOAD 1,* FROM [https://community.qlik.com/thread/205586] (html, codepage is 1252, embedded labels, table is @1);

DROP Fields [1], temp;

hope this helps

regards

Marco

Re: Merge two field into one in a table

Tue, 16 Feb 2016 04:22:36 GMT

Thanks everyone.

The answer of Sunny is working.

KR,

Hasvine

Re: Merge two field into one in a table

Anonymous — Tue, 16 Feb 2016 04:25:47 GMT

Rangesum also useful to merge to columns by using rangesum to merge the columns

Re: Merge two field into one in a table

Anonymous — Tue, 16 Feb 2016 04:27:24 GMT

example is RangeSum(Above(Sum(sale),-1,RowNo()))