Workflow Help
- 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
Hello,
Help needed on reconciling BB to AA based on quantity and character. The reconciliation will be on a 1/1, 1/multiple, multiple/multiple basis. The unique key identifying both sides is the ID. The output file should only have matching values. Thank you!
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Possible to share sample output ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Please find attached sample output. It should only return date and character for BB matching AA. Thanks!
- 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 Ponraj,
Thank you for your input! Can you please explain to me why you chose to use the cross tab tool?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I used cross tab tool to aggregate(To calculate sum) quantities of AA and BB ID wise and to position sum of AA and BB as two separate column values. Reconciliation will be easy if we have AA and BB quantities in two separate column against each unique ID.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks Ponraj! Let's say instead of AA and BB I had Only in Mum_House for AA and Only in Dad_House for BB. What expression will I use in the filter tool? Try using it within inverted commas and parentheses but it did not work.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Expression should be [Mum_House]=[Dad_House]
If it is not working, just share the sample data. Will help you with the workflow.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Ponraj,
Please find attached sample data. Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
