Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Why does a NULL value appear when I count to create a lead and validate duplicates?

avatar
Explorer

Hi!

I am generating a key by concatenating the fields and with the image script valid in impala that they are not duplicated, apparently there are no duplicates but I get NULL and this number is 148724. That is not true. There are no duplicates and there should be 0 records.

 

Kaviana_0-1663882105565.png

 

Thank you!

 

1 REPLY 1

avatar
Expert Contributor

To pinpoint the root cause, kindly provide a few samples of data