mehta_dipali

 Profile Answers by mehta_dipali Questions by mehta_dipali

• Mar 10th, 2008

 

I think this can not be done with single component. You can use scan component and assign serial number to all components. Use filter by to display requried records.

sixto.dsilva

 Profile Answers by sixto.dsilva Questions by sixto.dsilva

• Apr 15th, 2008

 

I think you can use the m_dump command to display records between 50-75
m_dump -start 50 -end 75
hope above command helps

njvijay

 Profile Answers by njvijay 

• May 11th, 2008

 

Another way of doing this is, using next_in_sequence() function and filter by expression component

abhi_fresh_as_dew

 Profile Answers by abhi_fresh_as_dew 

• Dec 11th, 2008

 

m_dump is 'THE' best for multiple file system.

For serial and mfs there are many ways the components can be used.

1.Filter by Expression : use next_in_sequence() >50 && next_in_sequence() < 75 for 1st requirement and next_in_sequence() !=5 for 2nd one.

2. We can also use multiple LEADING RECORDS component for meeting the requirement.

Abhisek B
fresh as dew!!

Nayak_AbIntio

 Profile Answers by Nayak_AbIntio 

• Jan 16th, 2009

 

If you have the access to Co>Op then you can try an alternate.

Say suppose the input file is : file 1

Use the Run programme component in GDE and write the below command:

`sed -n50,75p file 1 > file 2`

Your file 2 will be the required one.

idforshivani

 Profile Answers by idforshivani 

• Jun 20th, 2009

 

You have 100 records You want 50-75.

In UNIX you can use head and tail command




tail - 50f| head -25f

Ashutosh Prasad

 Profile Answers by Ashutosh Prasad 

• Sep 8th, 2012

 

You can use filter by expression component and in select statement you can use next_in_sequence()>=50 && next_in_sequence()< =75

:-)

harpreet singh

• Sep 20th, 2012

 

We cannot use next_in_sequence() function more than once in a transform. this next_in_sequence()>=50 &&next_in_sequence() <=75 wont give correct answer.

One way to do is:
Use reformat and add another field record_number and assign next_in_sequence() to it. Then in filter_by_expression : mention record_number >=50 && record_number < =75.

pramod

• Sep 21st, 2012

 

use LEADING RECORDS component
with condition
next_in_sequence()>=50 && next_in_sequence()< =75

sudharshan

• Jan 5th, 2013

 

sed -n 50,75p file1 > file2

srilakshmi

• Nov 12th, 2013

 

i/p----->f.b.e--------->
------>f.b.e-------->join------>o/p
get the all required records

kalyanvadlamudi2kn

 Profile Answers by kalyanvadlamudi2kn 

• Jan 8th, 2014

 

Assign a counter next_in_sequnce() for all records in the input using reformat and then in FBE use this
if ( counter > = 50 && counter < = 75 && counter != 55 ) 1 else 0

Rahul

• Sep 22nd, 2014

 

In filter by exp or reformat add this condition (while ( rec > 50 & < 75)
if(rec mod5 !=0)
select the record

Atin

• Oct 8th, 2014

 

m_dump -start 50 -end 25

siddardha

• Dec 10th, 2014

 

Use next_in_sequence function

milan

• Jan 7th, 2015

 

use m_dump < file_name> -start 50 -end 75

Kiran

• Apr 22nd, 2015

 

There are 2 ways to find the records in between 50-75.
1. We can find the records using Filter By Expression(FBE) component.
You can give transformation function as Param>50 && Param<<70.
2. We can find the records using Unix Command as Stream editor(Sed).

Shweta

• Jun 7th, 2016

 

Hi Pramod,
I suppose we can not use this component for capturing required records since it gives records only from starting. Next_in_sequence() can not be used in this component. We can give only numeric value.
let me know if you have anything I have missed out.

Jagnyadatta Sena

• Jun 10th, 2016

 

In serial processing Provide a filter expression in input dataset i.e. next_in_sequence() != 5 and use a reformat after it.
In output index of reformat, store next_in_sequence() value in a variable. while outing the record put the condition(Out :1: if(variable >=lower_value $$ variable <= upper_value ) {required port }) and send to out port and attach it to output file .

Shikha

• Mar 15th, 2020

 

You can use filter by expression in 1st FBE put condition
next_in_sequence() >=50 and invocation_number() <=75
and in 2nd FBE put condition
next_in_sequence() !=5

Krishna

• Aug 21st, 2020

 

What if we use (next_in_sequence() >=50 and invocation_number() <=75) and next_in_sequence() !=55 within the same FBE component?