Forum Discussion

Caitlin_Knox's avatar
Caitlin_Knox
Advocate III
9 years ago
Solved

Data modeling question

I'm hoping someone can at least point me in the right direction to do more research. I have a field in my data set that technically a single line text, but has multiple values separated by commas. Ho...
Need Help
Show and Tell
  • Sean's avatar
    Sean
    9 years ago

    Caitlin_Knox  Let me know if you have any questions...

     

    Hope this helps! :smileyhappy:

     

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Sean,

We have just set up a column in MSProject, within the Projects table, for Systems Impacted. At present only 5 projects have added details of systems impacted, but there are 5 possible systems so the column could have up to 120 variations.

Does your solution (the only one I've found to do what I need) mean that each time a new project is added or an additional impact is identified, we will need to go through the whole process of splitting/un-pivoting etc ?

 

Data so far

Project 1 - Systems affected - Alpha

Project 2 - Systems affected - Alpha, Beta

Project 3 - Systems affected - Beta, Gamma, Delta

Project 4 - Systems affected - Gamma, Delta

Project 5 - Systems affected - Alpha, Delta

 

Regards

Fred

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Sean,

 

As they say, "suck it and see" :smileyhappy:

I did and the refresh process works perfectly, grabbing new entries each time.  Thanks for the perfect solution.