Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Table Tool, Test Tool

lisamccullough
8 - Asteroid

Can the Test Tool create a separate report of unmatched data - or can any tool? Is Fuzzy Match a better tool?

 

I have 2 input reports - 1 is a Report and the other is a Table. I need to bring rows from the Table into my Report. I'm using the Join Tool but it doesn't look clean to me. Is this the best Tool to use? I used the Text Input Tool to bring in the table.

1 REPLY 1
KaneG
Alteryx Alumni (Retired)

My advice would be to use the Join tool. The advantage of this is you get the unmatched data out the sides of the Join. You may need to clean up the report to be just the data that's being checked. One other trick there is if you need to check multiple fields, then you can transpose them and join on Name/Value. If you wanted to create a message with the results then you can use a Message tool.

Labels