Issue Joining Datasets using Magic ETL Left Outer Join

Options

Hello, I am trying to join two datasets one is a huge datasets that has all employee numbers in the company and the other one is another dataset that has a list of different case numbers and a requester employee number that I am trying to validate the employee number and the their tiers using the bigger employee dataset by join the requester number column and the employee numbers column from the employee dataset. Whenever I try to join using left outer. it is not recognizing the and linking between the two columns

Best Answer

  • Sean_Tully
    Sean_Tully Contributor
    Answer ✓
    Options

    It's hard to know what the issue might be without seeing screenshots of the flow. One thing that comes to mind, though, is to make sure that the fields you're joining on are of the same type. If they don't match, you can change a field's data type in the input tile's Configuration > Data Handling.

Answers

  • fromMinnesota
    Options

    can you show examples of what you are doing and what error you are getting?

  • Sean_Tully
    Sean_Tully Contributor
    Answer ✓
    Options

    It's hard to know what the issue might be without seeing screenshots of the flow. One thing that comes to mind, though, is to make sure that the fields you're joining on are of the same type. If they don't match, you can change a field's data type in the input tile's Configuration > Data Handling.