Forum Discussion
naninamu
Helper IV
Helper IVMerging tables with large numbers of rows
Hi everyone. In theory I know how to do this, but the volume of data is giving me issues so need some help. Essentially, and this is simplified for the sake of this example, I have 2 tables. ...
There's a typo in your expected result - g is appearing 10 times not 9 times. So the total is 911, not 902.
You may want to try TREATAS as an alternative, it will likely perform better with larger data sets
lbendlin
Super User
Super UserThere's a typo in your expected result - g is appearing 10 times not 9 times. So the total is 911, not 902.
You may want to try TREATAS as an alternative, it will likely perform better with larger data sets
naninamuHelper IV
Helper IVJust on your point actually - do you mean use TREATAS to merge the 2 data sources? I did try this, but try as I might I couldn't get the syntax to work so I abandoned that path! Could you help with what that code might look like? Cheers.