Joining Data
- 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
I used to formula tool to calculate a number, then I use the text input tool to input 2 lines of data. I need the number calculated from the formula tool to populate in the 2 line of data I created. The first line is the exact amount from the formula tool and the second line is positive of the exact number.
I tried using the join tool it only created the heading only - no data was populated(blank). Used Join by Specific Fields.
Ex.
Formula tool - Total amount 3362009.462
Text Tool - Inputted info - I renamed the amount field as Total amount using the select tool.
I want the total amount to populate in a total amount field - One line 3362009.462 and the other line -3362009.462
Solved! Go to Solution.
- Labels:
- Error Message
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
A Join is reliant on field position or a common linking field, try using an Append Fields tool to match the data sets instead, with your table of one row feeding into the 'S' input anchor.
See the attached example to demonstrate the difference.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @kadenemcintosh,
I believe this is what you're trying to achieve, i've used a multi row formula to change the second row to positive while leaving the first as negative.
If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.
Regards,
Jonathan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Work perfectly. Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here you are @kadenemcintosh, can you post a screenshot of your error message or attach the workbook?
If this solves your issue please mark the answer as correct, if not let me know!
Regards,
Jonathan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I want to use the join tool to join the solution above and this data.
The result I am getting is blank.- I selected join by specific fields
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can you attach the workflow and files for me to take a look?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Try running a data cleanse tool before the join...your screenshot shows that there's some sort of issue with the data (the red line across the top) - likely leading or trailing spaces...the data cleanse tool will solve this, which should allow your join to work properly.
- 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
Can't run that workflow...your data file is linked to a shared drive
