This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Now that it's live, don't forget to accept your certification badge on Credly today! Learn more here.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email firstname.lastname@example.org for assistance.
If I understand you correctly, you're looking for the Join tool. It takes to datasets as inputs and then you configure what fields between them should be the keys used to lookup between them.
In your case, the configuration would be "Source" from "GetRequest" dataset is equal to "Destination" from "GetRepose" dataset, and as a second condition, "Destination" from "GetRequest" dataset is equal to "Source" from "GetRepose" dataset.
Contains records from the L input that didn't join to records from the R input.
Contains records that joined from the L input to the records in the R input.
Contains records from the R input that didn't join to records from the L input.
So, in your case, the J output anchor will have all Requests that found a matching Response, and the L & R output anchors will provide the Requests without a matching Response, and (if possible) and Responses without a matching Request.
I tried 'Join by position', it would join the data but the data in one column does not match the data in the other column. Then I tried the method you suggested 'Join by Specific field' with the options you gave, it would not join the data with the fields specified. I am not sure what the problem is.
Ok, I see. You've parsed out these fields from the log file, but most still have trailing and/or leading spaces. When the Join is performed, it's looking for an exact value match which includes any whitespace characters.
If you Browse your data, you'll see it warning about trailing & leading spaces with the Red triangle in the upper right corner of the cell & the Red bar under the Header of the field. Hovering over a cell will give you a tool tip with info about the whitespace:
To solve this just drop in a Data Cleansing tool after you have your fields parsed out before your flow starts splitting.