Intersection not working for shared value

michellelowsl

25-08-2020

Hi 

Anyone has experience or has any idea why two shared value from two table cannot be joined even after removing all spacing and turning everything into uppercase in the Enrichment? The intersection kept returning 0 even if the shared values are obviously the same from the interim results. Any suggestion is appreciated.

 

 

Accepted Solutions (1)

Accepted Solutions (1)

michellelowsl

01-09-2020

I have found a solution to my problem. I was using text field to join. It seems like there's a character limit when using text field as index for intersection. What I did was to substring the index text field into only shorter unique text. It's not ideal but it works.

e.g.

substring(Rtrim(Ltrim(Upper(@textfield))),1,12)

Answers (2)

Answers (2)

Sumit_Aleph

01-09-2020

HI,

 

in your expression editor use the condition eg : Lower(your value) also use the same Alias name for both activities inside the additional tab. 

 

 

ramon_bisswange

Employee

31-08-2020

Can you provide some more details? (E.g. screenshot etc.)

 

Is it standard or custom tables?