identifying column of join data

user08665
user08665 Member
in Magic ETL

 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. 

Best Answer

  • ST_-Superman-_
    ST_-Superman-_ Coach
    Answer ✓

    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?  


    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman

Answers

  • ST_-Superman-_
    ST_-Superman-_ Coach
    Answer ✓

    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?  


    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
  • user08665
    user08665 Member

    Thank you for your help!

    I could have joined data after RUN and SAVE!

    Thank you again for your help.

Categories