Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Intersection not working for shared value

Avatar

Avatar
Validate 10
Level 2
michellelowsl
Level 2

Likes

6 likes

Total Posts

43 posts

Correct Reply

2 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 10
Level 2
michellelowsl
Level 2

Likes

6 likes

Total Posts

43 posts

Correct Reply

2 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 1
View profile
michellelowsl
Level 2

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)

Avatar

Avatar
Validate 10
Level 2
michellelowsl
Level 2

Likes

6 likes

Total Posts

43 posts

Correct Reply

2 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 10
Level 2
michellelowsl
Level 2

Likes

6 likes

Total Posts

43 posts

Correct Reply

2 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 1
View profile
michellelowsl
Level 2

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)

Avatar

Avatar
Boost 1
Level 1
Sumit_Aleph
Level 1

Like

1 like

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
Sumit_Aleph
Level 1

Like

1 like

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
Sumit_Aleph
Level 1

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. 

 

 

Avatar

Avatar
Give Back 5
Employee
ramon_bisswange
Employee

Likes

243 likes

Total Posts

353 posts

Correct Reply

182 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 25
Give Back 10
Give Back
View profile

Avatar
Give Back 5
Employee
ramon_bisswange
Employee

Likes

243 likes

Total Posts

353 posts

Correct Reply

182 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 25
Give Back 10
Give Back
View profile
ramon_bisswange
Employee

31-08-2020

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

 

Is it standard or custom tables?