Write-back on Custom Query


Write-back on Custom Query

User will now be able to write-back on the results obtained from Custom query.

Step 1      Starting from creating a custom query rule, go to Manage Rules, click on Add Rule button, select Process Quality from drop down options and lastly click on Custom Query as shown in image below:



Step 2      User will be redirected to Add Rule detail page. In Basic Input section, under Customer Query box you will see the Enable Write-back check box as shown in image below:


Moving forward, select Data Source, Table name, provide Min and Max Threshold values and enter Custom Query.

Now here’s a situation, in case if that query contains key identifier already then Enable Write back check box will remain enabled. Select the Enable Write back check box and Save the changes. Skip below steps and go to Step 8 directly.

Please proceed with further steps if Enable Write back is disabled. User will be notified to set key identifier for the table in the Profiling as shown in image below: 



Step 3      Now in order to set the key identifier for the table go the main menu tab and select Profiling from there. On clicking it Profiling detail page will be displayed. Now select Source ID, Table name, click the More Action button, select Edit configuration option which will open the Configuration detail page. There you can set the key identifier field(s) and click the Save button as shown in image below:



Step 4      Now go back to the Manage Rules page and select the Rule ID for custom query rule that you have created, and it will open the Rule detail page. You will see a new tab showing up Write back Configuration. In case Write back is not enabled then it will appear as disabled. Also, on hovering it will notify user that Write back configuration is only accessible when Write back is enabled as shown below:



Step 5      In order to enable Write back, Select the Definition tab and from there click the Edit button as shown in image below:



On clicking Edit button it will display the Rule definition detail page. Under customer query text box, you will see the Enable write back check box as shown in image below:


 Step 6      Now click this Enable write back check box and hit the Save button as shown in image below:



On Saving it, the Write back Configuration tab gets enabled and user will be shown a Warning message that Rule definition has been updated and Re-run the rule as shown in image below:




Step 7      Now if user clicks the write back configuration tab then it will again show user a Warning message that Re-run the rule in order to write back on specified columns. User will click the Run button as shown in image below:



Step 8      Once user has re-run the rule then will show the Key Field Mapping further. This is to notify user earlier that write back operation cannot be performed on Key value(s) in custom query rule. Except those key value(s) users will be able to write back on any other field(s). Now click the Next button as shown below:



Step 9      On clicking the Next button user will be directed to next screen where all the columns that user has defined in custom query will be displayed except those Key identifier value(s). Here user will set the configuration criteria by selecting those column(s) name on which the write back is to be done. After that click the Save button as shown in image below:




Step 10      On Saving the changes, save button gets disabled and user is notified through a Warning message to Re-run the rule in order to see the updated results in Analysis tab. Now user clicks the Run button as shown in image below:



On Running the rule, warning message gets disappeared. Once user clicks the Analysis tab, fields will be highlighted that were set up for write back operation as shown in image below. Now user can cleanse and perform write back as same as it’s normally done for other rules.


Have more questions? Submit a request


  • 0
    Aashish Singhvi

    Excellent article. Thanks, Nuzha

Please sign in to leave a comment.
Powered by Zendesk