Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
sannidhikumar
Creator
Creator

Data Problem

Hi All ,

after removing synthetic keys the data is not matching properly .

any suggestions ,

thanks ,

9 Replies
m_woolf
Master II
Master II

Would have to see the data and the data model to comment.

jonas_rezende
Specialist
Specialist

Hi, pradeep kumar.

Please, share qvw with us.

Regards,

Jonas Melo.

sannidhikumar
Creator
Creator
Author

1.JPG

aapurva09
Creator
Creator

Hi,

You need to make sure the right keys are used for connection. Here in the screenshot it can be seen there are date related fields that are common. If you want your connection to include the date fields, they should be added in your 'Key' field.

Thanks

sannidhikumar
Creator
Creator
Author

Apurva ,

i already concatenated but the data is getting wrong any other solutions .

thanks ,

aapurva09
Creator
Creator

Can you share how you concatenated the fields to make 'Key' field?

sannidhikumar
Creator
Creator
Author

after concatenated i got this result .

2.JPG

sannidhikumar
Creator
Creator
Author

Apurva ,

i used concatenate fact table  then at last i got this result .  you can check the above synthetic keys Data Module.

thanks ,

sannidhikumar
Creator
Creator
Author

hi All ,

any one there to reply to this query .

thanks ,