How to Use Qlikview to Modify Table Layout? - Assistance Please

Wed, 17 Nov 2010 15:21:47 GMT

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);

How to Use Qlikview to Modify Table Layout? - Assistance Please

pover — Wed, 17 Nov 2010 15:40:08 GMT

Check out the following blog post that describes the generic load which does the opposite of the Crosstable() function.

http://community.qlik.com/blogs/qlikviewblogs/archive/2010/05/21/use-cases-for-generic-load.aspx

Regards.

topic How to Use Qlikview to Modify Table Layout? - Assistance Please in QlikView

How to Use Qlikview to Modify Table Layout? - Assistance Please

How to Use Qlikview to Modify Table Layout? - Assistance Please