DataPartition

sandeep87

• January 22, 2010 00:00

• Answered

Follow

hello all
i have a data with 6 fields. The data has errors in it like having null values in each filed etc.

So i need the error data records in one table and error free data in another table .

so how can i solve this problem?

Thanks in advance.
need it urgently

• 

  avackova

  • January 22, 2010 08:25

  0

  Comment actions Permalink

  Hello,
  if you only need to split data to two data flow the easiest way to do it, is to use ExtFilter component; if you want to add some information to wrong data use Reformat component.
  I strongly advice you to read the User's guide; many examples can be found on our Wiki pages (eg. Simple examples).
• 

  sandeep87

  • January 22, 2010 09:23

  0

  Comment actions Permalink

  i already tried the EXTFILTER but it was not working..
  
  Can i get an example of the expression that has to be written lets assume that i have a column POD, if i have to filter the records which have null value in the field POD . how the expression should be written?
  
  I am using the nodes directly , not the java code so please help me.
  
  Thanks to all
• 

  avackova

  • January 22, 2010 11:45

  0

  Comment actions Permalink

  In ctl just write

  isnull($0.POD)

  or

  !isnull($0.POD)

  
  depending on the port you want to get invalid data
• 

  sandeep87

  • January 22, 2010 12:20

  0

  Comment actions Permalink

  I am using PARTITION NODE
  i am not able to enter the RANGES for the partition key i specified.
  can u help me?
• 

  avackova

  • January 22, 2010 12:46

  0

  Comment actions Permalink

  Hello,
  partition function can also be written in ctl, eg.:

  function getOutputPort() {
  	if (isnull($POD)) return 0;
  	return iif($POD > 0, 1,2);
  }
  

  
  Above function sends record to port 0, if POD has null value, to port 1 if POD value is positive and to port 2 if POD value is negative or zero.
• 

  sandeep87

  • January 22, 2010 17:59

  0

  Comment actions Permalink

  Thank You very much for your replies...
  Helped me a lot.
  
  THANKS
  --Sandeep

Please sign in to leave a comment.