Comparing 2 datasets and Email missing records

[Karthick461]

Hi,

 I have 2 data sets. I need to compare 2 datasets and email if any of the field is not matching. both tables has same headers , but one table in row wise object and 2nd table is column wise object.

Dataset1 : 

Product   Object       Value
Apple     Distribution   01
Apple    Content         05
Apple     Content        06
Apple    Variance        02
Apple    Variance        03
Apple     Variance       04

Dataset 2:

Product  Distribution    Content        Variance
Apple      01                 05,06            02,03

When we compare these 2 , Variance '04' is missing. that we need to set Email as Product : Apple , Variance : 04

I have tried Transpose function for dataset 2 to convert records into column wise and tried Join tool to compare records with dataset 1. But Email function not working after join ..  Any way to achieve this

[Luke_C]

Hi @Karthick461 

Sounds like you're on the right track transposing and joining the second dataset! Can you share more about how you're setting up the email tool? 

[Karthick461]

@Luke_C ,

 From Join tool , Inner Join is giving proper matching records. 

 Left and Right Join is the missing Fields. I tried one new union tool after that and combined Left and Right of the earlier join and used Email tool directly. but its not working

[Luke_C]

Hi @Karthick461 

What about it isn't working? It would be helpful if you could share any error messages, screenshots of configurations, etc. It's very hard to diagnose otherwise. 

[Karthick461]

No error messages. I configured Email from Union.

In Email configuration , I have added Body field ( product name here ) . So I am getting output as Product : Apple . but actual requirement is to show Product : Apple , Variance : 04 ( which is actually missing for that product ).

Since its sample file , tried for one product(Apple) . Later i will run for around 80 products. 

[Luke_C]

Hi @Karthick461 

Try using a report text tool before the email. You can craft your message and swap in field data as needed. Check out the examples provided in designer if, they should hopefully be self explanatory.