Append new values
- 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, I have two tables with similar values. Example, table 1(template table) and Table 2 both have Area Code, however, the number of rows are not the same. I tried to use Find and Replace Tool, but it only returns the first match. For your reference, im attching pictures and sample workflow. Hope you can help me.
Table 1 (This is the template table)
Table 2 (this has values for Charge per HR and CGP which I need to append to Table 1 using their respective Area Code)
Table 3 (basically table 1 but now with values for Charge per hour and CGP) ps: All blanks will be set to 0 value
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@samxhander09
I use the Tile tool to predefine the Stack Order and put the data together.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Qiu it looks good, my friend. thank you for helping and teaching me about a new tool(new to me)!
