Hi everyone, this is my first post so I just wanted to say thanks for all the help in the past. I've been using this forum for a while and have always been able to find the answer to my questions until now.
I performed an extraction of the data that I needed for a project and it came out as:
ID#1 | Note1 | Note2 | Condition4 | Condition2 | State1 | State3
ID#2 | Note2 | Note5 | Note7 | Condition2 | Condition5 | Condition1 | State3 | State6 | State3
Ideally, the way it should read is (for reasons explained below)
ID#1 Note1 Condition4 State1
Note2 Condition2 State3
ID#2 Note2 Condition2 State3
Note5 Conditon2 State3
Note7 Condition1 State3
What I need to do is take all the IDs and based on their condition and states, flag them or pass them.
Furthermore, one ID can have 30+ different notes but the format will always remain the same (Note1 Note2 Note3 Note4 ... etc)
There's a list of combinations of six conditions and six states put into a table.
For example, the table that states that:
Condition1 | State1 | Pass
Condition1 | State2 | Pass
Condition1 | State3 | Pass
…
Condition3 | State3 | Flag
Condition3 | State4 | Flag
…
Condition6 | State6 | Flag
If even one of the conditions and states is a flag, then the ID should be flagged as well. It would be easier to do if the table was arranged in the ideal format but since it isn't, is there a workaround or a way to maybe even turn it into the ideal format?
I hope this is clear but feel free to ask for further clarifications if required! There are > 700,000 entries in my table so this would be very useful.
I have attached an Excel file as well that may help clarify the problem.
I performed an extraction of the data that I needed for a project and it came out as:
ID#1 | Note1 | Note2 | Condition4 | Condition2 | State1 | State3
ID#2 | Note2 | Note5 | Note7 | Condition2 | Condition5 | Condition1 | State3 | State6 | State3
Ideally, the way it should read is (for reasons explained below)
ID#1 Note1 Condition4 State1
Note2 Condition2 State3
ID#2 Note2 Condition2 State3
Note5 Conditon2 State3
Note7 Condition1 State3
What I need to do is take all the IDs and based on their condition and states, flag them or pass them.
Furthermore, one ID can have 30+ different notes but the format will always remain the same (Note1 Note2 Note3 Note4 ... etc)
There's a list of combinations of six conditions and six states put into a table.
For example, the table that states that:
Condition1 | State1 | Pass
Condition1 | State2 | Pass
Condition1 | State3 | Pass
…
Condition3 | State3 | Flag
Condition3 | State4 | Flag
…
Condition6 | State6 | Flag
If even one of the conditions and states is a flag, then the ID should be flagged as well. It would be easier to do if the table was arranged in the ideal format but since it isn't, is there a workaround or a way to maybe even turn it into the ideal format?
I hope this is clear but feel free to ask for further clarifications if required! There are > 700,000 entries in my table so this would be very useful.
I have attached an Excel file as well that may help clarify the problem.