Output preview not available for Inner Join
Hi Team,
I’m using an Inner Join and observing that the output preview doesn’t appear. Is this an expected behaviour?
I however, have access to the data I’m expecting out of Inner join (as I’m wr...
Forum Discussion
Look at the preview data for the Join’s two inputs. Can you find a pair of documents from each view that should be joined?
If not, try increasing the preview count to 2000.
Long story short: No however I was expecting it to appear that’s the reason Sort snap was used. If results are random, I can remove the sort snap as it is an overhead to the pipeline and would impact the performance.
The results are not random.
Can you please switch the preview type of the Sort output to display JSON instead of Table? I want to see if the NAME value is a string or a number.
Sure, please find the below screenshots for your reference:
Ok, thanks. The data you’re showing ARE sorted. The Sort is just like the Join or any other snap. It’s only going to sort the data that it receives on its input. If you’re doing a validate instead of an execute and your preview doc count is 50, the Sort is only going to sort 50 records. That appears to be exactly what it’s doing.
