Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

qliekview
Contributor II

join two fields in same table

join.png

I have two fields in same table I want to put two fields values in one column

Tags (1)
2 Replies
sivarajs
Valued Contributor II

Re: join two fields in same table

Try the example below

LOAD * , SubField(ID&','&ID1,',') as New_field Inline [

ID,ID1

100,101

102,103

];

Not applicable

Re: join two fields in same table

Hi,

U can write a script like,

Load *

          ,UniteAdiG1&'#'&UniteAdiG2 as NewField

From SomeTable;

Regards,

Kabilan K

Community Browser