Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You want to Sum them or Concat them into a third row?
I want to have A and B in new coulm with new value C
C = A , B
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
I need to use group by in QV or I can use sql query