topic Re: merge cells in script in QlikView

merge cells in script

Wed, 25 Nov 2020 16:16:04 GMT

i have a coulm I wanna merge to cells together

Header 1
name
A
B

name in my coulm name @

A & B are my cells in coulm name

I want to creat a new coulm and merge A & B to C

Re: merge cells in script

sunny_talwar — Mon, 12 Dec 2016 12:41:31 GMT

You want to Sum them or Concat them into a third row?

Re: merge cells in script

Mon, 12 Dec 2016 13:07:16 GMT

I want to have A and B in new coulm with new value C

C = A , B

Re: merge cells in script

MarcoWedel — Mon, 12 Dec 2016 22:54:57 GMT

Hi,

one solution might be:

tabName:
LOAD name
FROM [https://community.qlik.com/thread/243053] (html, codepage is 1252, embedded labels, table is @1, filters(Remove(Row, Pos(Top, 1))));

Join
LOAD Concat(name,',') as NewColumn
Resident tabName;

hope this helps

regards

Marco

Re: merge cells in script

Mon, 19 Dec 2016 06:14:43 GMT

I need to use group by in QV or I can use sql query