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
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.
Got it but I was expecting Sort snap to change these results. I mean, I get your point based on the inputs a snap receives but it will take me some time to sink this fact.
