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.

923 questions
956 answers
953 comments
1,782 users