The above is a screen dump of an Excel log that we wish to load into Qlikview.
Each Column is a Staff member and depending on whats populated into the cell on a particular date determines whether they are on Holidays (H) or in work (Null)
When I load this into Qlikview , the fields are now the list of staff names. I wish to have a Staff Name Field and a date field , I believe the below format is a more prudent load. Is it possible to amend the data within the load , or do I need to fix the Spreadsheet prior ?
Any help or thoughts on this , would be greatly appreciated !!! It looks like a big job me thinks !