DataPartition

CloverDX Platform
1

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

2

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

3

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

4

In ctl just write

isnull($0.POD)

or

!isnull($0.POD)

depending on the port you want to get invalid data

5

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

6

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.

7

Thank You very much for your replies…
Helped me a lot.

THANKS
--Sandeep