Guys,
I'm writing a new Progress result query but the output has duplicate result, please example see below:
Item Description Safety Stock On Hand On Order Qty WIP Alc Jb
------- ------------ ------------ -------- ------- ------- --------
1-0121 xxxx FOR xxx 2,630.00 3,124.00 0.00 0.00 158.00
1-0121 xxxx FOR xxx 2,630.00 3,124.00 0.00 0.00 158.00
1-0121 xxxx FOR xxx 2,630.00 3,124.00 0.00 0.00 158.00
1-0121 xxxx FOR xxx 2,630.00 3,124.00 0.00 0.00 158.00
1-0121 xxxx FOR xxx 2,630.00 3,124.00 0.00 0.00 158.00
How do I combine all the same results into one line, like this:
Item Description Safety Stock On Hand On Order Qty WIP Alc Jb
------- ------------ ------------ -------- ------- ------- --------
1-0121 xxxx FOR xxx 2,630.00 3,124.00 0.00 0.00 158.00
Please see my attached query file. Appreciated your help!
I'm writing a new Progress result query but the output has duplicate result, please example see below:
Item Description Safety Stock On Hand On Order Qty WIP Alc Jb
------- ------------ ------------ -------- ------- ------- --------
1-0121 xxxx FOR xxx 2,630.00 3,124.00 0.00 0.00 158.00
1-0121 xxxx FOR xxx 2,630.00 3,124.00 0.00 0.00 158.00
1-0121 xxxx FOR xxx 2,630.00 3,124.00 0.00 0.00 158.00
1-0121 xxxx FOR xxx 2,630.00 3,124.00 0.00 0.00 158.00
1-0121 xxxx FOR xxx 2,630.00 3,124.00 0.00 0.00 158.00
How do I combine all the same results into one line, like this:
Item Description Safety Stock On Hand On Order Qty WIP Alc Jb
------- ------------ ------------ -------- ------- ------- --------
1-0121 xxxx FOR xxx 2,630.00 3,124.00 0.00 0.00 158.00
Please see my attached query file. Appreciated your help!