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.
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.