Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All ,
I have been trying on below data to get required output since long time.
I have data like below :
Field |
User : Kalyan |
Loc: |
City |
Dest |
Code |
1001 |
1002 |
1003 |
1004 |
1005 |
1006 |
1007 |
User : Ravi |
Loc: |
City |
Dest |
Code |
2001 |
1007 |
1004 |
User : Shiva |
Loc: |
City |
Dest |
Country |
Code |
2008 |
2010 |
2003 |
3289 |
3892 |
8221 |
I want output like below :
User | Code |
Kalyan | 1001 |
Kalyan | 1002 |
Kalyan | 1003 |
Kalyan | 1004 |
Kalyan | 1005 |
Kalyan | 1006 |
Kalyan | 1007 |
Ravi | 2001 |
Ravi | 1007 |
Ravi | 1004 |
Shiva | 2008 |
Shiva | 2010 |
Shiva | 2003 |
Shiva | 3289 |
Shiva | 3892 |
Shiva | 8221 |
Can anyone tell me how to achieve this in back end?
!
Hi,
what is the rule to map the codes and the users ?
May be as below: