Hey,
I've run into a bit of a snag while processing some data.
Basically, I have two tables in .txt format, each containing about 1.2 million entries.
The issue, of course, is that Google Sheets just can't handle a dataset this massive.
What I actually need to do is this:
Both tables share two common columns, but the second one has a third column that I need to map back to the first set based on those two.
The logic I'm looking for is basically:
IF A & B (from the first workbook) equals A & B (from the second workbook), then insert C (from the second workbook).
If this weren't such a huge amount of data, it wouldn't be a big deal. I could just sort columns A and B in ascending or descending order and manually paste column C from the other file.
But the whole problem is that the volume of data I need to import/link exceeds what Google Sheets allows.
Does anyone have any ideas on how to tackle this?
To make things slightly more complicated, column A has some duplicates (around 30 or so), while column B has roughly 60k unique values. It’s crucial that column C from the second file maps exactly to the corresponding A and B columns.
One thing I forgot to mention is that the first workbook has its own additional column C.
Book 1 contains:
MSISDN TEXT SN
Book 2:
MSISDN TEXT STATUS
And the end result should look like:
MSISDN TEXT STATUS SN
Does anyone know a way to pull this off, or maybe suggest another program that can handle this kind of scale?
Thanks in advance for any help.
I've run into a bit of a snag while processing some data.
Basically, I have two tables in .txt format, each containing about 1.2 million entries.
The issue, of course, is that Google Sheets just can't handle a dataset this massive.
What I actually need to do is this:
Both tables share two common columns, but the second one has a third column that I need to map back to the first set based on those two.
The logic I'm looking for is basically:
IF A & B (from the first workbook) equals A & B (from the second workbook), then insert C (from the second workbook).
If this weren't such a huge amount of data, it wouldn't be a big deal. I could just sort columns A and B in ascending or descending order and manually paste column C from the other file.
But the whole problem is that the volume of data I need to import/link exceeds what Google Sheets allows.
Does anyone have any ideas on how to tackle this?
To make things slightly more complicated, column A has some duplicates (around 30 or so), while column B has roughly 60k unique values. It’s crucial that column C from the second file maps exactly to the corresponding A and B columns.
One thing I forgot to mention is that the first workbook has its own additional column C.
Book 1 contains:
MSISDN TEXT SN
Book 2:
MSISDN TEXT STATUS
And the end result should look like:
MSISDN TEXT STATUS SN
Does anyone know a way to pull this off, or maybe suggest another program that can handle this kind of scale?
Thanks in advance for any help.