I've been playing around with BC4 and like what I've been able to do so far but would like to know if the following is possible before I purchase:
I have two CSV files with one key column. File 1 has a couple hundred thousand entries and file 2 has around ten thousand entries. I'd like to delete all rows in file 1 except for the ones that match data in the key column in file 2. I would then like to move some columns from file 2 into file 1 but in a way where the data corresponds to the key column.
I've been able to do the matching part just from playing around but I don't really know what I'm doing and it's sort of messy. I'd appreciate some clear steps.
Thanks
I have two CSV files with one key column. File 1 has a couple hundred thousand entries and file 2 has around ten thousand entries. I'd like to delete all rows in file 1 except for the ones that match data in the key column in file 2. I would then like to move some columns from file 2 into file 1 but in a way where the data corresponds to the key column.
I've been able to do the matching part just from playing around but I don't really know what I'm doing and it's sort of messy. I'd appreciate some clear steps.
Thanks
Comment