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

Answer Question  Select Best Answer

Input file has below contents:
Ball Run
1 1
2 1
3 1
4 1
5 1
6 1
1 0
2 1
3 1
4 1
5 1
6 1
1 1
2 1
3 1
4 1
5 1
6 0

Required Output :
1 6
2 5
3 5

UNKNOWN User

• Oct 23rd, 2024

Use rollup with key change function
(in1.ball==6 && in2.ball==1)
This will cover if the 6th ball is a extra ball

Shubham Kandpal

• Jun 22nd, 2024

Use key change and rollup , this code is 100% working

Code
 

Answer Question  Select Best Answer

I have header and trailer records to some body records like below
emp.dat|12042016
1/A/1000
2/B/2000
3/C/3000
3
Here there is no record indicator.
How will you eliminate and separate header and trailer records without using Next In Sequence, Dedup sorted and any Partition components?

Vicky Gupta

• Dec 6th, 2024

Input File-> Filter by Expression -> Output File

select expr = not (string_index(id,|)>0 or string_is_numeric(id))

Somasekhar Ganta

• Aug 8th, 2024

You dont need so many components to achieve this write input dml as one column like below record string(" ") data; end; and Just connect Reformat and give count parameter to 3 for 3 out ports and...

Answer Question  Select Best Answer

Suppose I have a scenario like below:
Input:
======
Id Col1 Col2
a 100 Null
a Null 200
b 300 Null
b Null 400

And I need output as:
Output:
=======
Id Col1 Col2
a 100 200
b 300 400

How to get only Not NUll Values?

Iffath

• Dec 13th, 2023

Use Rollup with key as id and in transform use sum() function. mention fields as nullable in dml"mysql out::rollup(in) = begin out.id :: in.id; out.col1 :: sum(in.col1); out.c...

Vishnu

• Dec 12th, 2023

Does it works on GDE 1.1

Answer Question  Select Best Answer

In input dataset i am having 100 records. I want records between 50-75 and i don't want to read 5th record? which component i have to use..

Krishna

• Aug 21st, 2020

What if we use (next_in_sequence() >=50 and invocation_number()

Shikha

• Mar 15th, 2020

You can use filter by expression in 1st FBE put condition
next_in_sequence() >=50 and invocation_number()

Answer Question  Select Best Answer

vijay

• Nov 14th, 2017

Air sandbox run is the command to run abinitio graphs in Unix.

Mounika

• Jul 22nd, 2016

Go to run directory path:
/.../sandbox/run > air sandbox run /(graph_path)/sandbox_name/graphname.mp

if any graph level parameter is to be overridden then..
go to run directory path:
/.../sandbox/run > air sandbox run /(graph_path)/sandbox_name/graphname.mp -parameter_name parameter_value

Answer Question  Select Best Answer

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 ...

Answer Question  Select Best Answer

I have customer details as below,


cust_card_no item amount

10001 pen 10
10001 copy 20
10001 pen 10
10001 copy 20
10001 copy 20

now my question is to find the distinct count of item per customer and total ammount spend by a customer?

Shubam Salaria

• Aug 3rd, 2023

What does vector_search() func do?

anjali

• Sep 14th, 2020

Car_no item count amount
1001 copy 3 60
1001 pen 2 20
is it the desired output ?

Answer Question  Select Best Answer

I have input like 1,2,3-7,8,9 How to generate output like below
1
2
3
4
5
6
7
8
9

Ahmad Ali Quraishi

• Jan 6th, 2024

Normalize: out::length_of(in) begin let decimal("")[int] vec = allocate_with_default(); vec = if(string_index(in.id,"-")>0) string_split(in.id,"-") else vector_append(vec,in.id); out :: if(leng...

Neelima

• Aug 25th, 2022

out :: reformat(in) = begin let int i = 0; let string("")[]dv = string_split(string_replace(in.line,"-",","),","); let int count=length_of(dv); let string("...

Answer Question  Select Best Answer

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

Answer Question  Select Best Answer

Raj

• Nov 20th, 2018

I am yet to work on Ab Initio. What I see from this thread is no one knows, the exact differences between the Roll Up and Aggregate apart from the Performance. Every transform will have its own capabi...

sateesh44

 Profile Answers by sateesh44 Questions by sateesh44

• Apr 12th, 2011

Aggregate and ROLLUP generates records that summarize groups of records. But Roll-up provides more control over record selection, grouping, and aggregation.

Answer Question  Select Best Answer

sriks

• Dec 3rd, 2013

Co>op : 3.1.6
GDE : 3.1.6

shan88

 Profile Answers by shan88 Questions by shan88

• Oct 22nd, 2013

3.1.3

Answer Question  Select Best Answer

How do you find the size of MFS file?

Vinoth raj

• Mar 29th, 2012

Use m_ls -ltr file name you will have the record count and also size of it.

PN Reddy

• Feb 9th, 2012

Using m_expand you can know the count of partition on the file

Answer Question  Select Best Answer

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...

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

Answer Question  Select Best Answer

How can I achieve cummulative sumary in AB Initio other than using SCAN component. Is there any inbuilt function available for that?

mk_44

 Profile Answers by mk_44 Questions by mk_44

• Feb 9th, 2016

I guess below code can help for 3rd max else 1st max for each group key. Input_file --> sort (descending) --> Rollup --> output type temporary_type=record decimal("") rank ; decimal("") sal ...

disha

• Jan 22nd, 2016

@Dinesh: but it is not taking care of the requirement, i.e. if there is no 3rd record, it should display the first highest sal. In the solution you mentioned it will display the second highest sal.

Answer Question  Select Best Answer

I have 100 records in input file if I run graph first time first 20 records will go to output, in next run 21 to 40 records will go to output, like this in 5th run 81 to 100 records will to output. Please let me know how can I achieve this?

Thanks in advance

siva

• Apr 17th, 2018

Use the Partition by round robin component and set the block size 20

Natrayan

• May 16th, 2017

We can use the Partition by range component to segregate the record based on record number

Answer Question  Select Best Answer

I have a scenario like below:

Date Amt
01-01-2016 100
01-01-2016 300
02-01-2016 350
01-01-2016 200
02-01-2016 150
02-01-2016 400
01-01-2016 250
02-01-2016 250

I want to find top to transactions on each date:

Amaan Sajid Ansari

• Nov 14th, 2018

Use SORT---> SCAN (use scan select function and set the value as < =2)

Krushna

• Sep 7th, 2018

Sort on date and amount(descending) then use scan to assign number within group then filter records whose number

Answer Question  Select Best Answer

jakirajam

 Profile Answers by jakirajam Questions by jakirajam

• Jul 25th, 2010

"version it"  institute is not  teaching ab initio course;By jakirajam

jakirajam

 Profile Answers by jakirajam Questions by jakirajam

• Jul 25th, 2010

Hello 2.18.32 is new version for co op and 1.18 is new version for GDE.Ok keep it up . By jakirajam

Answer Question  Select Best Answer

jatin

• Apr 30th, 2018

1. In memory components where input not need not be sorted is selected like Rollup,join,scan,
2. Sort component

sonalika

• Sep 21st, 2017

Sort breaks pipeline parallelism

Answer Question  Select Best Answer

How to print the position of the char in a given word

I have a input like:
Column_name:
Indicator
YNNYYN
NNNYYN
YYYYYN
NNNNNN

REQUIRED O/P:
Where the Y is present in a given string, i want position of the string with CONCATENATE of P Letter.

o/p:
P1
P4
P5
P4
P5
P1
P2
P3

shivank b

• Apr 4th, 2021

The simplest solution would be using reformat with below function.
out.data :: string_concat("P",(decimal(1))string_index(in.column_name,"Y"))

Regards,
Shivank B

RR

• Jan 22nd, 2021

How do you define the output format of Reformat here?

Answer Question  Select Best Answer