Answered Questions

  • Feb 02 2013
    12:10 PM
    15948
    35

    Pulling out the records which are same in two records

    • Azeemuddin2204

    I have two files and I want to compare those two records ,after comparing I want to pull out the records which are same in both records and I want the new record from the unmatched records record format is like this: decimal(3) CUST_ID; string(6) CUST_NAME; string(" ") ADDRESS; same for two files; and my records are 01 sidhu hyd 02 phani bng 03 hasnu che 04 azeem vtm ...

    Ahmad Ali Quraishi

    • Jan 6th, 2024

    1.Use one file as lookup file and another as input file.
    2. Use Filter by expression component and we can use !lookup_match("Lookup1",cust_id") in FBE

    Anand Kishore

    • Oct 7th, 2022

    Keep a file as lookup.
    Use the syntax as lookup_match to get matching file and the rejected records are non matching record

  • Jun 18 2009
    02:41 PM
    15512
    24

    Force_error Function
    • mhero

    How does force_error function work ? If we set never abort in reformat , will force_error stop the graph or will it continue to process the next set of records ?

    raja

    • Feb 9th, 2015

    Force_error function will not throw any error when we keep the reject threshold as never abort. but it will reject all unwanted records per requirement and will provide you the message.

  • May 24 2008
    12:18 PM
    35009
    52

    Output for sort and dedup sort with null key
    • abinitio17

    I have file containing 5 unique rows and I am passing them through SORT component using null key and and passing output of SORT to Dedup sort. What will happen, what will be the output.

    Amaan Sajid Ansari

    • Nov 14th, 2018

    In Case of sort output would be same as input (unsorted) in case of dedup will depend on no of partition and the dedup method used. Please refer to the other similar dedup question i have explain it in that

    san

    • Aug 7th, 2018

    1. In case of Null ket{} in sort component nothing will happen. 2. In case of Dedup sorted - keep - fist then you will get first record, Keep- Last then you will get last one, Keep- Unique only - in ...

  • Feb 10 2008
    12:06 PM
    32308
    66

    Abinitio EME
    • shylender

    In my sandbox i am having 10 graphs, i checked-in those graphs into EME. Again i checked-out the graph and i do the modifications, i found out the modifications was wrong. what i have to do if i want to get the original graph..?

    Amruta

    • Jan 9th, 2021

    Do revert changes...
    Another option is to checked out previous version of object from eme

    Jatin Chawla

    • Sep 21st, 2020

    Air object rollback to rollback to previous version

  • Sep 07 2006
    06:28 PM
    19686
    34

    Why go for sort within groups?
    • prabhupurna

    We have sort and sort within groups components. we can achieve the sort within group functionality by placing two keys in sort group. Then why we have to go for sort within groups?

    Mahesh

    • May 26th, 2021

    One of the other examples could be :
    graph A has done PBKS on field A
    and when the output of graph A is being read by graph B it needs data to be sorted on fieldA and fieldB so major key is fieldA and minir key is fieldB.This saves time and increases performance.

    sundar

    • May 5th, 2015

    Hey Munmun,

    Do we need sorted data to sort with in group or component will taking care?

    Thanks