Forum Discussion
Solved
Merging two tables
I feel like I'm completely missing something here. I'm not sure if I'm just doing this wrong but I can't seem to merge these two tables. Essentially, I have two tables pulled from different sources, ...
I FIXED IT! You were right, something was wrong with that column, I did a split column and got rid off whatever was causing the issue. Kind of weird since I didn't see anything.
Hi @Jamuza,
Are you sure that both colimns from wich you want to merge the tables have the same data? Do.you have any spaces in the end of the text in one of them that makes the information be different for example.
Regards,
MFelix
Are you sure that both colimns from wich you want to merge the tables have the same data? Do.you have any spaces in the end of the text in one of them that makes the information be different for example.
Regards,
MFelix
Hi,
I'm pretty positive they're the same. Here's an example of two same items:
- Are the columbs both formatted in the same way? Sorry for asking.again.are you sure the columns are exactly the same? Add a column with the length of the merging columns and compared them, I ask this because I had cases in.wich I.was also sure of the columns being equal and there were spaces in one of.them.
MFelixSo I created a brand new column and tried to merge them both, still the same issue. They're both text, I also tried a merge different tables and it does work, so that leads me to believe something is wrong with one of my tables. Is there a way to format the table to match the other tables?
I FIXED IT! You were right, something was wrong with that column, I did a split column and got rid off whatever was causing the issue. Kind of weird since I didn't see anything.