on 03-14-2017 8:09 PM
Hi,
Is it possible that a copy operator can copy NULL values from source to target?
If no, Is there are paramater in COPY function, that can help in nullifying the values of Target KF before the values of Source KFs are copied into it?
Regards,
Sourojit
Hi Sourojit,
What do you try to achieve? A copy operator can create NULL values with the scope to initialize planning objects if CREATE_TIMEPERIODS parameter is selected.
Best
Alecsandra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Sourojit,
Ideally copy operator will take care of it. It will copy all the data from source KF including NULL and complete overwrite the target KF.
If you want to delete the target KF Values before hand to be on safer side, you have 2 options
1. New Advance copy operator with "Clear Value" option, which will be NULL target KF - this requires another copy operator hence I don't use and recommend.
2. Use Version deletion operator to delete the KF values before running the copy operator - I always use and recommend this option to clear any KF values.
I hope this helps, please let me know if you have any question.
Thanks
Girish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Sourojit,
Have you got the parameter to copy null value through copy operator , where source KF is having null value ?
Regards
Ganga
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Alecsandra,
In my scenario, I am having two KFs: KF1 (Source KF) and KF2(Target KF). KF1 is initially having NULL values in some periods while KF2 is having vales in all bucket. Now if I execute copy, all the values in KF1 (including NULL) should get copied into KF2. Please tell me, if this is taken care of by default by the COPY operator? Or is it that my Copy Operator should have CREATE_TIMEPERIODS to enable copying of NULL values?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.