Data Blending
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Topic of Interest
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @subin1234,
Can you please share a workflow for further assistance?
John Posada
Cloud Engineer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can use Summarize tool configured with all the resulting fields with the actions "First" to get the desired result.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Do you have any sample workflow that can solve my issue
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Please find the attached excel file.
Here the order number in the excel file is not same as the one which is used to explain the requirement.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
