I have table A (Operation) and table B (PART_SITE). There are values in table A that I'd like to add to table B, note that table A and B have no values in common and are not connected to each other. I've tried concatenating, mapping and a left join but non seemed to have worked or perhaps I haven't done it correctly. Any insight will be greatly appreciated.
In your original post, you wrote: "note that table A and B have no values in common and are not connected to each other". If there are no common values, such as a key or an identifier, a mapping cannot be achieved.
Yes, that's to be exected. If you had a common identifier in both your tables, you would however already be able to achieve what you're looking to do: Show values from both tables in one chart.
