Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a data like this I want to count the status(Complete,Incomplete) of their respective , Need help in creating a data model into a straight table
Sample Data:
id |
Application | ABC | ||||||||||
1.1.1 | 1.1.2 | 1.1.3 | 1.1.4 | 1.1.5 | 1.2.1 | 1.2.2 | 1.2.3 | 1.2.4 | 1.2.5 | 1.2.6 | 1.2.7 | |
SCOPE | ASSESMENT | Internal REVIEW | Review L | Info Gathering | Identify Primary | Complete Registration | Validate Database | Create accounts | Accounts in ABC | Data Profiling | Access Governance | |
123 | Complete | Incomplete | Complete | Incomplete | Incomplete | NA | Complete | Incomplete | Complete | Incomplete | Incomplete | NA |
124 | Complete | Incomplete | Complete | Incomplete | Incomplete | Complete | Complete | Incomplete | Complete | Incomplete | Incomplete | Complete |
125 | Incomplete | Incomplete | Incomplete | Incomplete | NA | Incomplete | Incomplete | Incomplete | Incomplete | NA | ||
126 | Complete | Incomplete | Complete | NA | Complete | Complete | Complete | Incomplete | Complete | NA | Complete | Complete |
127 | Complete | Incomplete | Complete | Incomplete | Incomplete | NA | Complete | Incomplete | Complete | Incomplete | Incomplete | NA |
128 | NA | Incomplete | NA | Incomplete | Incomplete | NA | NA | Incomplete | NA | Incomplete | Incomplete | NA |
129 | Complete | Incomplete | Complete | Incomplete | Incomplete | Incomplete | Complete | Incomplete | Complete | Incomplete | Incomplete | Incomplete |
130 | Complete | Incomplete | Incomplete | complete | Incomplete | NA | Complete | Incomplete | Incomplete | complete | Incomplete | NA |
131 | Complete | Incomplete | Complete | Incomplete | Complete | NA | Complete | Incomplete | Complete | Incomplete | Complete | NA |
132 | Complete | Incomplete | Complete | Incomplete | Incomplete | NA | Complete | Incomplete | Complete | Incomplete | Incomplete | NA |
Need a model on the above sample data
Hi
See this post as an example on how to load excel cross table with multiple header
Thanks for the response, Can you please Help me with the Model, I have 3 Nested here,
1) Application
2) Version
3) Stage
Can anyone write a code on this that would be helpful