Hello all, I'm New to Qlik.
I cannot find anything in the HR demo files to help so here is my plea.
I've been sent on some classroom Qlik courses (designer and Dev) so I have a grounding in the Qlik'verse. Of course the training and materials are all around sales and HR data doesn't play as nice. I'm also heavily indoctrinated in relational data thinking (and excel for my sins)
The short version is that I have years of monthly reports. They are excel files with 4 sheets. Active Staff, Active contractors, Starters and Leavers. This data does not exist anywhere else due to system changes and the fact things are overwritten with no audit trail.
I want to interface with them through Qlik so I have loaded them in and as there are 11+ common fields I'm in synthetic key hell.
This is what I'm looking at cleaning up.
$Syn 1 (2 & 3 & 4) = Report_Date
+Person_Type_Description
+Person_Name
+Position_Name
+Grade_Name
+Short_Job_Title
+Position_Title
+Start_Date
+Assignment_User_Status
+Employment_Category
+Region
+Organisation_Name
+Supervisor_Name
$Syn 5 = $Syn 1+$Syn 3
$Syn 6 = $Syn 1+$Syn 2
$Syn 7 = $Syn 1+$Syn 2+$Syn 3+$Syn 4
$Syn 8 = $Syn 5+$Syn 6+$Syn 7
Has anyone seen a solution to a similar situation that I could repurpose?
Ideally we'll have 92 excel files 'imported' Which just about hits 1,000,000 records. But for now 12 or 24 months would be a win.
They span several versions of excel (csv,xls,xlsx,xlsm etc etc) which makes VB reformatting of them all next to impossible so I'm hoping I can bring them all in to qlik.
My current thinking is bring each of the above 11 fields in AS [sheetprefix]fieldname,
Then somehow LOAD another table to allow then to exist properly.
I'm looking mapping load or a link table.
Any help or pointers would earn you piles of internet kudos from me.
Did I say hello?
Thanks for reading.
Message was edited by: Oliver Whitton
in response to request
