How to Use Qlikview to Modify Table Layout? - Assistance Please
I have been given a MS Excel spreadsheet that looks like the following
Name DateType Date Adam Date Hired Nov 7 2008 Bob Date Worked May 6 2010 Mary Date Dismissed June 7 2010
This format continues on through about 40,000 rows. There are several other fields in each record, I have just isolated the ones that need to be manipulated.
The spreadsheet needs to be modified so that the unique date type entries becoming field/column headings. This will allow only 1 row for each employee instead of 3.
Table load looks as follows. Any suggestions will be appreciated.
LOAD IDNumber as ID, [Last name], [First name], [Middle name], [Personnel Number] as Employee, [Birth date], SocSecNumber, [Gender Key] as Gender, PA, [Personnel Area], PArea, [Payroll Area], [Date type], Date, [Div/Dept], [Employment Status] FROM (ooxml, embedded labels, table is Sheet1);
