Qlikview query

Sunil_26 — Mon, 27 Jun 2022 07:03:23 GMT

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

Re: Qlikview query

sidhiq91 — Mon, 27 Jun 2022 07:19:08 GMT

@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