{"action":"opened","issue":{"url":"https://api.github.com/repos/OpenRefine/OpenRefine/issues/954","labels_url":"https://api.github.com/repos/OpenRefine/OpenRefine/issues/954/labels{/name}","comments_url":"https://api.github.com/repos/OpenRefine/OpenRefine/issues/954/comments","events_url":"https://api.github.com/repos/OpenRefine/OpenRefine/issues/954/events","html_url":"https://github.com/OpenRefine/OpenRefine/issues/954","id":59465716,"number":954,"title":"Cross function doens't produce the desired results","user":{"login":"mobaset","id":11269444,"avatar_url":"https://avatars.githubusercontent.com/u/11269444?v=3","gravatar_id":"","url":"https://api.github.com/users/mobaset","html_url":"https://github.com/mobaset","followers_url":"https://api.github.com/users/mobaset/followers","following_url":"https://api.github.com/users/mobaset/following{/other_user}","gists_url":"https://api.github.com/users/mobaset/gists{/gist_id}","starred_url":"https://api.github.com/users/mobaset/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mobaset/subscriptions","organizations_url":"https://api.github.com/users/mobaset/orgs","repos_url":"https://api.github.com/users/mobaset/repos","events_url":"https://api.github.com/users/mobaset/events{/privacy}","received_events_url":"https://api.github.com/users/mobaset/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-03-02T10:52:54Z","updated_at":"2015-03-02T10:52:54Z","closed_at":null,"body":"I have two datasets that I need to merge. Basically, I need to retrieve two columns from dataset 2 into dataset 1 using cross function. Dataset1 has 271300 rows, dataset2 has 22000 rows. I'm using a column as a key in dataset1 to lookup the value if matched in dataset2. Not all keys in dataset1 are available in dataset2, but that is fine. The problem is, when using Cross function on the entire dataset1, the result is 0 rows. If I filtered down the rows to a smaller number, the function works. But after some comparison in Excel, I found that Open Refine didn't lookup all the values.\r\n\r\nIs this a known bug?\r\n\r\nI'm using Open Refine 2.5 (r2407), i have java 1.8 & java 1.6 installed. \r\n\r\nThanks,\r\nMo"}}