Matching Values

[vinod2086]

Hi friends,

I have a below table in that some of the columns emp_id is blank. so my req is if sales id is present and emp id is blank in that case need to display new column as status yes else No.

sales_id	sales_name	sales	emp_id	emp_name
1	aaa	10		zz
2	bbb	20		xx
3	ccc	30	123	yy
4	ddd	40	456	tt
5	eee	50	789	vv

Thanks,

[tamilarasu]

Hi Kumar,

Load *,

If(Len(Trim(emp_id))=0, 'Yes','No') as Status;

LOAD * INLINE [

    sales_id, sales_name, sales, emp_id, emp_name

    1, aaa, 10, , zz

    2, bbb, 20, , xx

    3, ccc, 30, 123, yy

    4, ddd, 40, 456, tt

    5, eee, 50, 789, vv

];

[vinod2086 · Accepted solution]

Thanks for reply nag,

i got solution simply i applied if condition

if(IsNull(EMP_ID) and not IsNull(SLS_TTY_ID),'y','n')as new

this condition is working.

[Anil_Babu_Samineni]

You can try this too

If(emp_id= '', 'Yes','No') as Status

OR

If(Trim(emp_id)= '', 'Yes','No') as Status

[tamilarasu]

I assume that sales_id field cannot be null and thus suggested the above solution.  Anyways, you go the solution. Have a nice day.