UNSOLVED
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
787
0
Posted July 17th, 2015 12:00
Thank you, I raised SR#72781564
DavidRussell1
141 Posts
787
0
Posted 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