Visokio website     Downloads     Video tutorials     KnowledgeBase  
DataManager: Replacing data value? - Visokio Forums
DataManager: Replacing data value?
  •     grahamb March 18, 2013 6:42AM
    Hi, this might be a silly question but I have a field called [AREA] that has 3 values. One of these is 'UK'. I wanted to change the values from 'UK' to 'DDMS' so created a calculation to do this. In the query I I did a test and selected a few records that were UK and these correctly appeared as DDMS. However when I do a reload 'UK' remains. How do I change this value so all views of the data analysis remain with three categories to select upon?
    Attachments
    data_replace.png 59K
  • 1 Comment
  •        daniel March 18, 2013 1:24PM
    Use the DataManager Operations block called Search and Replace instead of a formula and place it between the Excel source file Import block and the loaded, in-memory blue Omniscope block. You just have to set the block to search within the [Area] field and automatically replace all values "UK" with "DDMS".

    The method you used probably did not work because you were using an existing field, alternatively you can create a new formula field [Area2] and rewrite your function as:

    IF([Area]="UK","DDMS", [Area])

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership