Automic Workload Automation

  • Private Community

  • 1.  Duplicates values in Vara

    Posted Jan 10, 2018 06:58 AM
    Hi All,

    I am new to Automic and got struck in the middle of development, i am having a vara with some values and few values are repeated(or we can say duplicates values)  now i want to read the vara line by line and were ever i find the repeated values i need to copy those values to new vara.
    How can i do this?

    Thanks,
    Vikram.G


  • 2.  Duplicates values in Vara

    Posted Jan 10, 2018 08:34 AM
    Hi Vikram,

    here is a simple example comparing Value1....value5 of a VARA object and writing duplictaes to a result VARA:

    ! Set source VARA
    :SET &VARA# = "VARA_DUPL"
    ! Set result VARA
    :SET &RESULT_VARA# = "VARA.DUPL_RESULT"
    !
    !clear result VARA
    :DELETE_VAR "VARA.DUPL_RESULT"
    !
    !Looping for every row through VARA
    :SET &HND_1# = PREP_PROCESS_VAR(&VARA#)
    :PROCESS &HND_1#
    :  SET &KEY_A# = GET_PROCESS_LINE(&HND_1#, 1)
    :  SET &VAL_A1# = GET_PROCESS_LINE(&HND_1#, 2)
    :  SET &VAL_A2# = GET_PROCESS_LINE(&HND_1#, 3)
    :  SET &VAL_A3# = GET_PROCESS_LINE(&HND_1#, 4)
    :  SET &VAL_A4# = GET_PROCESS_LINE(&HND_1#, 5)
    :  SET &VAL_A5# = GET_PROCESS_LINE(&HND_1#, 6)
    !
    !2nd loop to compare Values 1...5
    :  SET &HND_2# = PREP_PROCESS_VAR(&VARA#)
    :  PROCESS &HND_2#
    :    SET &KEY_B# = GET_PROCESS_LINE(&HND_2#, 1)
    :    SET &VAL_B1# = GET_PROCESS_LINE(&HND_2#, 2)
    :    SET &VAL_B2# = GET_PROCESS_LINE(&HND_2#, 3)
    :    SET &VAL_B3# = GET_PROCESS_LINE(&HND_2#, 4)
    :    SET &VAL_B4# = GET_PROCESS_LINE(&HND_2#, 5)
    :    SET &VAL_B5# = GET_PROCESS_LINE(&HND_2#, 6)
    !
    :    IF &KEY_A# <> &KEY_B#
    ! checking if value of loop 1 and loop 2 are identical
    :      IF &VAL_A1# = &VAL_B1#
    :        PRINT "Duplicate value found: &KEY_A# -- &VAL_A1#"
    :        PUT_VAR &RESULT_VARA#, &KEY_B#, &VAL_B1#, &VAL_B2#, &VAL_B3#, &VAL_B4#, &VAL_B5#
    :        PRINT "PUT_VAR &RESULT_VARA#,&KEY_B#,&VAL_B1#,&VAL_B2#,&VAL_B3#,&VAL_B4#,&VAL_B5#"
    :      ENDIF
    :    ENDIF
    !
    :    IF &KEY_A# <> &KEY_B#
    :      IF &VAL_A2# = &VAL_B2#
    :        PRINT "Duplicate value found: &KEY_A# -- &VAL_A2#"
    :        PUT_VAR &RESULT_VARA#, &KEY_B#, &VAL_B1#, &VAL_B2#, &VAL_B3#, &VAL_B4#, &VAL_B5#
    :        PRINT "PUT_VAR &RESULT_VARA#,&KEY_B#,&VAL_B1#,&VAL_B2#,&VAL_B3#,&VAL_B4#,&VAL_B5#"
    :      ENDIF
    :    ENDIF
    !
    :    IF &KEY_A# <> &KEY_B#
    :      IF &VAL_A3# = &VAL_B3#
    :        PRINT "Duplicate value found: &KEY_A# -- &VAL_A3#"
    :        PUT_VAR &RESULT_VARA#, &KEY_B#, &VAL_B1#, &VAL_B2#, &VAL_B3#, &VAL_B4#, &VAL_B5#
    :        PRINT "PUT_VAR &RESULT_VARA#,&KEY_B#,&VAL_B1#,&VAL_B2#,&VAL_B3#,&VAL_B4#,&VAL_B5#"
    :      ENDIF
    :    ENDIF
    !
    :    IF &KEY_A# <> &KEY_B#
    :      IF &VAL_A4# = &VAL_B4#
    :        PRINT "Duplicate value found: &KEY_A# -- &VAL_A4#"
    :        PUT_VAR &RESULT_VARA#, &KEY_B#, &VAL_B1#, &VAL_B2#, &VAL_B3#, &VAL_B4#, &VAL_B5#
    :        PRINT "PUT_VAR &RESULT_VARA#,&KEY_B#,&VAL_B1#,&VAL_B2#,&VAL_B3#,&VAL_B4#,&VAL_B5#"
    :      ENDIF
    :    ENDIF
    !
    :    IF &KEY_A# <> &KEY_B#
    :      IF &VAL_A5# = &VAL_B5#
    :        PRINT "Duplicate value found: &KEY_A# -- &VAL_A5#"
    :        PUT_VAR &RESULT_VARA#, &KEY_B#, &VAL_B1#, &VAL_B2#, &VAL_B3#, &VAL_B4#, &VAL_B5#
    :        PRINT "PUT_VAR &RESULT_VARA#,&KEY_B#,&VAL_B1#,&VAL_B2#,&VAL_B3#,&VAL_B4#,&VAL_B5#"
    :      ENDIF
    :    ENDIF
    !
    :  ENDPROCESS
    :  CLOSE_PROCESS &HND_2#

    :ENDPROCESS
    :CLOSE_PROCESS &HND_1#




  • 3.  Duplicates values in Vara

    Posted Jan 11, 2018 06:12 AM
    Hi Wolfgang Brueckler,

    Thanks for your inputs, my requirement is i am having a duplicates in row 3,so i need to read the duplicates values in row 3 and store the details in new vara. 
    Please can u provide me your inputs on this.

    Regards,
    Vikram.G


  • 4.  Duplicates values in Vara

    Posted Jan 11, 2018 08:45 AM
    Thats easy cheesy - in this case just drop all IF paragraphs that do NOT contain:
    :      IF &VAL_A3# = &VAL_B3#
    cheer, Wolfgang


  • 5.  Duplicates values in Vara

    Posted Jan 17, 2018 10:04 AM
    Hi FrankMuffke

    Vikram`G613237 is asking how to trace same(duplicate entries) in a single column of vara. not with two diff varas. 

    Ex: 
    col1    col2     col3 
    1         FOX    Forest
    2         Tiger    Cage
    3         Wolf    Forest 

    how to trace "Forest" cos its appearing twice (more than once) in col3.  


  • 6.  Duplicates values in Vara

    Posted Jan 17, 2018 01:07 PM
    Hi

    yeah - and because its only one VARA to check I have following lines in my script:

    ! Set source VARA
    :SET &VARA# = "VARA_DUPL"
    ...
    ...
    ...
    :SET &HND_1# = PREP_PROCESS_VAR(&VARA#)
    ...
    :  SET &HND_2# = PREP_PROCESS_VAR(&VARA#)


    cheers, Wolfgang