This content has been marked as final. Show 2 replies
I am having a problem with one field that is being pulled from Sharepoint.
It basically is a lookup field that can contain numerous data:
- This is a change management report tool which lists the number of change requests per application
- A group of Change Requests are piled up into a Release
The problem arises that when in Qlikview, looking at what CRs are included in a Release the field looks like:
|Release ID||Rel Name||Associated CRs|
|3||Release C||CR1; CR3; CR4; CR5|
|Change ID||CR Name|
In order to accurately link the CR in the Release table (A), to the CR objects (table B) I need to somehow extract the objects out individually.
I have tried using the
SubField([Associated CRs], ';') as NewField function but it only brings back the first CR from the left while leaving all the other ones (CR3,4 and 5 in example above)
Is there a way of returning the Release table to look like this?
|Release ID||Rel Name||Associated CRs||NewField|
|3||Release C||CR1; CR3; CR4; CR5||CR1|
|3||Release C||CR1; CR3; CR4; CR5||CR3|
|3||Release C||CR1; CR3; CR4; CR5||CR4|
|3||Release C||CR1; CR3; CR4; CR5||CR5|