0 votes
I am trying to joint two csv datasets based on two numeric keys. Checked consistency between meaning and data format, and all kinds of different types of join, and in all cases I get a log saying over 340 thousand records have been added, but no row is shown in the explorer. Always says "no matching rows", even though I am left joining, in which case at least the left dataset rows should appear.

It is as if the resulting dataset is empty. Could not find a clue in the log and had to move to another platform in order to perform the join.

Thanks

Reinaldo
asked by Reinaldo
Where do you read this "no matching rows" message? If the dataset was empty you wouldn't see this, but a prompt to build it.
Could you give us a bit more details? The logs from the job could help too.

Please log in or register to answer this question.

792 questions
816 answers
720 comments
533 users