Separating arguments from a cell in Excel worksheet upon loading in Qlikview
Trying to figure out how to separate arguments within a cell from an Excel spreadsheet upon the load into Qlikview app. I have attached a sample. I will need the script rather than the .qvw. I was familiar with the Peek function when I have data in separate rows. This question is when the arguments are in the same row. Here is what I started with for scripting:
Re: Separating arguments from a cell in Excel worksheet upon loading in Qlikview
You are correct. For the header I have scripted that with changing to capture on the load. so when I load it I delete that row. My question is about the subsequent rows where I want to make row 3 into 2 separate rows because of column 6 (Reference ETN) has two arguments.