ADF DataFlow Data Preview showing 'No Output Data' while using Inner Join

Question

I have an adf DataFlow that has two Sources , Source A is a parquet file and Source B is an Excel File. I am using an inner join to get the matching records in both the sources. But when I do a data preview it doesn't not show any values , it just says 'No Output Data'. I have verified there are matching record between those two sources.
But for some reason the Inner join activity is not showing the values. I have updated the Debug Setting to increase the debug row limit but still no data. I've tried updating the data type of the matching Id's to make they are same, changed the excel to parquet to see if the data type/file miss match was causing this issue but nothing worked. Please advise.
Thank you!

Answer 1

Hello @BalwinderKaur-5937 ,
Thanks for the question and using MS Q&A platform.

As we understand the ask here is Join not work between thwo paraquet source , please do let us know if its not accurate.
I did a very simple test , got two paraquet files ( 2 different source ) and then tried to JOIN then on the same field . And it did worked fine for me .

Can you please share the paraquet files/excel file with dummy data , so that we can run atest on our side .?

Please do let me if you have any queries.
Thanks
Himanshu

---

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
  • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

Answer 2

Hello @HimanshuSinha-msft

Thank you for your response, yes the issue has been resolved, actually the issue was on the data side, logic was right.

Thanks again!