Skip to Content

How do i remove #MULTIVALUE ERROR

Feb 28 at 05:53 AM


avatar image

Hi All.

I have Three detailed variable (PK1, PK2,PK3) Created on merged dimension Number. These PK1, PK2,PK3 are coming from different queries. I am getting a #MULTIVALUE error under PK3.

For ex

Number PK1 PK2 PK3

111 Pack1 Pack2 pack3

112 Pack1 Pack2 pack3

113 Pack1 Pack2 #MULTIVALUE

I know the reason for MULTIVALUE : ie For Each number there are more than one records under PK3.

QUES: How can i remove the multivalue error and split in into two records

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers