You are reading a single comment by @Chalfie and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@Chalfie
is sheet 1 loaded as a table and as a connection only? same with sheet 2?
Ideally, I think - happy to be wrong,
solution 1 :these should be separate tables in a data location then you could have a third table just doing it all by lookup @aggi has a lookup solution i've used from here but can't find.
solution 2 : you have a unique key for each row? and then just merge on this.
If it's this big shouldn't it be done in flow/automate?
(is it really a billion rows? why?)