Fetch the sub string from the parent string and remove the null values..

[Kohli]

Hi Team. I have Field like these

EmpID

1.00

2.00

3.00

4.00

        (Null Value)

5.00

6.00

10.00

12.00:

I want  output like thease

EmpID

1

2

3

4

5

6

10

12;

[ChennaiahNallani]

try this

Table:

Load * Inline [

EmpID

1.00

2.00

3.00

4.00

5.00

6.00

10.00

12.00];

table1:

Load

num(EmpID,'##') as EmpID_no

Resident Table;

[francescoreggia]

Table:

Load * where isnull(EmpID)=0 ;

Load * Inline [

EmpID

1.00

2.00

3.00

4.00

5.00

6.00

10.00

12.00];

[ujjwalraja]

Hi,

Use this code

Table:

Load Floor(EmpID) as EmpID

where isnull(EmpID)=0;

Load * Inline [

EmpID

1.00

2.00

3.00

4.00

5.00

6.00

10.00

12.00];