Intersection not working for shared value | Community
Skip to main content
M
michellelowsl
Level 3
August 25, 2020
Solved

Intersection not working for shared value

  • August 25, 2020
  • 3 replies
  • 2586 views

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.

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by michellelowsl

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)

3 replies

B
Adobe Employee
bisswangAdobe Employee
Adobe Employee
August 31, 2020

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

 

Is it standard or custom tables?

M
michellelowslAuthor
Level 3
September 1, 2020
Hi @bisswang, they are both custom tables. I found that there's character limit to the text index used for join. I have resolved it by using substring. Let me know if there's better way to do it 🙂 Thanks
S
Sumit_Aleph
September 1, 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. 

 

 

M
michellelowslAuthor
Level 3
September 1, 2020

Thanks Sumit. I did. I have LTrim, Rtrim and uppercase the value. I found that there's character limit to the text index used for join. I have resolved it by using substring. Let me know if there's better way to do it 🙂 Thanks

M
michellelowslAuthorAccepted solution
Level 3
September 1, 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)

Terms & ConditionsAccessibility statement

Loading footer...