Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Every1,
I need your help.. 🙂
please find attached the excel input data file for section access.
Prj_No | Task_No | Manager | Executive | Amt |
1101 | 1 | SRINI | MANISH | 100 |
1101 | 2 | SRINI | MANISH | 110 |
1101 | 3 | SRINI | SACHIN | 120 |
1102 | 1 | MANISH | SRINI | 210 |
1102 | 2 | MANISH | SRINI | 220 |
1102 | 3 | SACHIN | RAHUL | 230 |
i have already implemented section access on Column "EXECUTIVE" i.e, if i select MANISH then already my section access is working fine but i have another requirement.
If i select any Executive then i need to search the same value in the MANAGER Column & show the relavant amounts because the executive can also be a Manager on the same or on different project codes.
Section Access to be implemented on Manager and Executive (2 Columns)
For example.,
If NTUSER "MANISH" logs in then it should search for this value in MANAGER column and show me the output as below
1102 | 1 | MANISH | SRINI | 210 |
1102 | 2 | MANISH | SRINI | 220 |
in the same way another NTUSER SRINI log in then his actual amount as a executive is coming fine but i also want to show the values as a manager & the output should be as below.
1101 | 1 | SRINI | MANISH | 100 |
1101 | 2 | SRINI | MANISH | 110 |
1101 | 3 | SRINI | SACHIN | 120 |
Need your help & suggestions for the same.. 🙂
Thanks in Advance..
Rgds,
srini
Hi All,
I would like to thank you all for your valuable Suggestions,
I have got the Solution.
First I have Loaded the resident of the Same Table Twice but in First Resident load only the Manager Name & in second Resident Loaded Table load only the Executive Name and concatenate both the tables.
It will result in a common Name which can be used for comparison for any number of Expressions.
ForExample:
For First Expression i can Say if(ExecutiveName = CommonName,Amt)
For Second Expression -- if(ManagerName=CommonName,Amt)
The script will Look Like below---
MainTable:
Load
Project_No&'-'&Task_No as CommonLink,
Project_No,
Task_No,
Executive Name,
ManagerName,
Amt
from ExcelFile.Xls;
CommonTable:
Load
Project_No&'-'&Task_No as CommonLink,
ExecutiveName as CommonName
Resident MainTable;
concatenate
Temp:
Load
Project_No&'-'&Task_No as CommonLink,
ManagerName as CommonName
Resident MainTable;
I am able to get a CommonName & using Set Analysis i am able to achieve my output.
Thanks again for all your Suggestion but still i am looking at the Performance on a Hight Data Volumes.
Rgds,
Srini