Checking the value of field in falt file

[Former Member]

hi,

I had query that...

how to check whether the field coming from flat file always contains a value or not..

thanking u

guna

[Former Member · Accepted solution]

Hi,

U can check with two options.

Using grahical mapping std functions:

1) Input value and Constant value with space give it to Equals function which will either give true or false based on true or false u can come to know whether value is present or not.

2) using UDF.

pass the input to UDF and write a small java code.

if(a[0].equals(""));

{

result is false

}

else

{

result is true

}

chirag