Hello Everyone, I am a newbie to Alteryx Designer. I have a question regarding the data matching. For Example Let us say I have two tables GetRequest SourceDestinationDescriptionhostDevice_1GetRequesthostDevice_2GetRequesthostDevice_3GetRequesthostDevice_4GetRequest GetResponse SourceDestinationDescriptionDevice_2hostGetResponseDevice_1hostGetResponseDevice_4hostGetResponse I want to know what devices are sending the 'GetResponse' after sending the 'GetRequest' and seperate the devices that are not sending. Please let me know if you have a possible solution Thanks Hari

Search for matching name in another column and seperate the data found

Hello Everyone,

I am a newbie to Alteryx Designer. I have a question regarding the data matching. For Example

Let us say I have two tables

GetRequest

Source	Destination	Description
host	Device_1	GetRequest
host	Device_2	GetRequest
host	Device_3	GetRequest
host	Device_4	GetRequest

GetResponse

Source	Destination	Description
Device_2	host	GetResponse
Device_1	host	GetResponse
Device_4	host	GetResponse

I want to know what devices are sending the 'GetResponse' after sending the 'GetRequest' and seperate the devices that are not sending.

Please let me know if you have a possible solution

Thanks

Hari

Workflow

Topic of Interest

Output

Apps

Accepted answers

MattBSlalom

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.

All comments

MattBSlalom

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.

From Join tool Help (Join Tool | Alteryx Help😞

The 3 outputs that result from the join are...

L anchor	Contains records from the L input that didn't join to records from the R input.
J anchor	Contains records that joined from the L input to the records in the R input.
R anchor	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.

hchepyal

Thanks Matt,

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.

Regards,

Hari

MattBSlalom

I'm not sure what you have in your workflow, but it works as described for me. See the attached sample.

join sample.yxmd

hchepyal

I am sharing my workflow and a test data. Could you please let me know where I was going wrong?

MattBSlalom

You have 60 rows coming into this filter tool:

None of those rows are evaluating to True.

So your T output anchor has no data flowing through it; therefore, both of your Joins have no data for their L input anchors.

hchepyal

Forgot to change the hostname to 'ito022614.hosts.cloud.com' in the filter that I sent to you. Even after changing it, the join condition is not satisfying

MattBSlalom

To solve this just drop in a Data Cleansing tool after you have your fields parsed out before your flow starts splitting.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703