Linking data in Qlikview from CSV where key is on a seperate row
I have a csv file where details of the key are on a different row. I want to be able to link the preceeding key to the data rows after until the next key point.
For instance data:
Each detail is in a separate row after the tow with the key. The data is pulled into a single column. I am able to create the key table and a detail table in Qlikview, however, I struggle on linking the details to the corresponding key. There is no unique number of details after the key. I've looked at using the Peek() and the Previous() functions, but cant see how to bring it together.
Any and all assistance will be greatly appreciated.