Hi Guys,
My data looks like this
Here if the article_number , order_item and order_number is same, I want to have my result in a single row having all the column as above.
here is how the output should look
Please help me to solve the issue
Regards,
Subin
Solved! Go to Solution.
Hi @subin1234,
Can you please share a workflow for further assistance?
You can use Summarize tool configured with all the resulting fields with the actions "First" to get the desired result.
Do you have any sample workflow that can solve my issue
Hi ,
My data looks like this
In my case as u can see from above picture i am having one order number AFR99048106 having same article number and same order item number. Also Shipping date is "4/26/2018 10:19" , shipping quantity is "2" and Shipping status is "SHIP" in 9 th row. Also Delivery Date is "4/26/2018 15:10" delivery quantity is "2" and Delivery Status is "DELIV".
In my output I should have order number AFR99048106 with Shipping date as 4/26/2018 10:19, shipping quantity as 2 Shipping status as "SHIP",Delivery Status is "DELIV" in a single row
Please help me to solve the issue
Also find the attached workflow created so far. I want to modify the output of "Union" tool in the workflow
If u could help me on this, its highly appreciated.