Concatenate more rows to one row

[djaykumar]

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

[StarinieriG]

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

;

[djaykumar]

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 

[djaykumar]

Attachment

[StarinieriG · Accepted solution]

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
];

[djaykumar]

Thanks StarinieriG

Now its working perfectly

Jay