merge cells in script

[#1]

hi

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

[sunny_talwar]

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

[#3]

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

C = A , B

[MarcoWedel]

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

[#5]

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