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.
Thank you @ptaylor for your quick response.
This opens up a new discussion as Sort snap’s output preview is not aligned with the exported results. I have tried validating it with Shift + Validate but haven’t found any luck. Some screenshots might help you understand this in detail:
Output preview of snowflake execute:
As the Name field is string in snowflake, used the following in the mapper:
Sorting it in ascending order so that the order matches with the flat file:
Output preview of Snowflake Sort:
This is amusing as if you check the exported flat file, the results will come in ascending order (snaps shared in my previous comment)
