Unsolved
This post is more than 5 years old
8 Posts
0
1018
June 23rd, 2015 11:00
How to set a key on external SQL source
Hello,
I'm on 6.2 SP1
I'm trying to merge external data from an SQL query with the Backup Client Config Data Source but I'm unable to set a key on the external source. I tried using they key field from the source parameter with no success. I also tried the SetKey Operator and still not working.
My merge is then not working since my external data has no key.
Any ideas ?
Thank you
No Events found!
DavidRussell1
141 Posts
0
June 24th, 2015 00:00
Hi Ben,
From what I can tell you appear to be doing everything correct
I would recommend raising a support ticket so that support can investigate the cause.
As a workaround you could try using the Group By operator afterwards and group by your 2 key fields. That should make those 2 fields keys, and will ensure there is 1 row per unique combination of those 2 fields.
Thanks
David
Ben122
8 Posts
0
July 17th, 2015 12:00
Thank you, I raised SR#72781564