How to extact two fields( more than one) in pig nested foreach

[#1]

Hi All,

According to my requirement i need script like following

A = load '/bsuresh/sample' USING PigStorage(',') as (id,name,sal,deptid);
 B = GROUP A by deptid;
 C = foreach B {
         D = A.name,A.sal;--two fields
	 E = DISTINCT D;
         generate group,COUNT(E);
};

In relation 'D', i am extracting two fields.Where exactly i am facing error.

If i chnaged the script like,which is working fine.

C = foreach B {
         D = A.name; --one filed
 	 E = DISTINCT D;
        generate group,COUNT(E);
};

But i need count based on distinct of two columns .Can any one help me??

[#2 · Accepted solution]

@Suresh Bonamhave you looked at Concat?

[#3]

Yeah ...@Artem Ervits i got your point.simple but logical.

[#4]

@Suresh Bonam let me know if that works for you and close the thread :).