Qlikview query

[Sunil_26]

Hi all,st 

I want to combine the data from the second field into the first field,

please check the images below i need second image as output data.

Thanks

[sidhiq91]

@Sunil_26  Please see below:

NoConcatenate
Temp:
Load * Inline [
Content, Data
My name is, XYZ
My country is, AUS
My Region is, Sydney
];

NoConcatenate
Temp1:
Load Content&' '& Data as Content
Resident Temp;

Drop table Temp;

Exit Script