identifying column of join data

user08665

 let me know if domo checks all of [identifying column] when join data.

I tried to join data with attached [TestData.xlsx], then got no result.

I know when i put mached ID ahead of the Data1, I can get joined data, while mached ID are not always ahead of the data set actually.

with above result i wonder if DOMO checks only ahead ID of data set. 

TestData.xlsx

ResultOfJoinData.png

ST_Superman

This join should work.  I know the preview when using ETL is not searching the entire data set, but I had assumed it was searching further than 100 rows of data.  Do you get the same result when you save and run the entire data flow?