topic Re: Concatenate more rows to one row in QlikView

Concatenate more rows to one row

djaykumar — Sat, 16 Nov 2024 20:03:58 GMT

Hi All,

I am struggling with the concatenation of rows into single row.

please find sample Data and required Output.

Please help me in this.

Thanks

Jay

Re: Concatenate more rows to one row

StarinieriG — Wed, 18 Sep 2019 07:28:10 GMT

Hi,

probably you need group by

Load

Material,

storage,

batch,

Max(Unrestricted) as Unrestricted,

Max(Blocked) as Blocked,

Max([In Qual. Insp]) as [In Qual. Insp],

Max([Restricted-Use]) as Restricted-Use,

Max(Returns) as Returns

From table

Group by

Material,

storage,

batch

;

Re: Concatenate more rows to one row

djaykumar — Wed, 18 Sep 2019 11:08:26 GMT

Hi StarinieriG,

Thank you for quick reply

I am getting correctly for the below required scenario in sheet2.

But I am not getting existing data which I am getting correctly in sheet1.

Please find attachment that now I am not getting scenario in sheet1

I need both the scenarios to be met.

Thanks,

Jay

Re: Concatenate more rows to one row

djaykumar — Wed, 18 Sep 2019 11:40:18 GMT

Attachment

Re: Concatenate more rows to one row

StarinieriG — Wed, 18 Sep 2019 12:08:34 GMT

Seems that Batch is not inside the group by.

Trying to load this script, it works well.

Load

Material,

Storage,

Batch,

Max(Unrestricted) as Unrestricted,

Max(Blocked) as Blocked,

Max([In Qual. Insp]) as [In Qual. Insp],

Max([Restricted-Use]) as [Restricted-Use],

Max(Returns) as Returns
Group by

Material,

Storage,

Batch
;
load * inline
[Material,Storage,Batch,Unrestricted,Blocked,In Qual. Insp,Restricted-Use,Returns
Bolt,SPSL,342,0,2,0,0,0
Bolt,SPSL,520,3,0,0,0,0
];

Re: Concatenate more rows to one row

djaykumar — Thu, 19 Sep 2019 05:12:32 GMT

Thanks StarinieriG

Now its working perfectly

Jay