Comparing 2 datasets and Email missing records

Question

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 · Answer

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.

Karthick461 · Answer

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 · Answer

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.