Processing field arrays/multiple columns of same data elements
I'm having a data modeling/loading issue that I need some assistance with.
My data, which is coming from a relational database, contains records that have multiple fields for the same information. For example, a customer record may have from zero (0) to five (5) licenses associated with it, defined as:
What is the best way to load this data into Qlik Sense such that only one of each field (e.g., LIC_NUMBER, LIC_TYPE, LIC_STATUS_CODE, LIC_NAME, LIC_EFF_DATE,LIC_END_DATE) and containing from zero to five data values is associated with each customer in Qlik Sense?
Re: Processing field arrays/multiple columns of same data elements
Thanks for the reply. A couple of things that I didn't mention previously are:
There are about 500,000 records in the database table that I'm pulling from.
For each of those 500,000 records, in additional to the other unique/distinct fields, there are nine separate field groupings per record, each containing from zero to five data values. The license information mentioned in my first post is one of the nine groupings associated with each record.
With this additional information would there be a more efficient way to load the information rather than repeatedly reading through the source data multiple times?