Qlik Gold Client Key Split Enhancement Overview

[Steve_Chabala]

Key Split is a performance tuning option within Qlik Gold Client. Introduced in Qlik Gold Client 8.7.3, it is used to control which tables allow for splitting of table content in different Data Flows for export/import. This functionality is triggered when the configured table is a Header table in a Data Type, where it will split the table entries.

The benefit is to allow Gold Client to parallelize the import of data in the same table using multiple jobs, making the import process much faster.

Key Split is to be used carefully and for very specific export/import scenarios, especially when there is a performance issue importing tables on a target system. To maximize the functionality, parallel processing option must be used.

At this moment, some special table type fields like GUID, RAW, STRING, XSTRING, etc. should not be used with Key Split.

There are 4 different types of Key Split options available within Qlik Gold Client:

1. Alphanumeric

For a specific range of documents, it will separate the documents by the first alphanumeric digit and create a Container for each of them.

A, B, C, …, 0, 1, 2, …, Special Chars.

Example:   B123456789 (this entry will be added with all that start with “B”)

2. Alphanumeric by Grouping (introduced in Gold Client 8.7.4 Patch 3 – 8.7.2024.05)

For a specific range of documents, it will separate the documents by the first alphanumeric digit grouping and creating a Container for each of them.

A-C, D-F, G-I, J-L, M-O, P-R, S-U, V-X, Y-Z, 0-2, 3-5, 6-8, 9-Special Chars.

Example:   B123456789 (this entry will be added with all that start with “A* B* or C*”)

3. Numeric

For a specific range of documents, it will separate the documents by the last numeric digit and create a Container for each of them.

0, 1, 2, 3, 4, 5, 6, 7, 8, 9

Example:   123456789 (this entry will be added with all which last digit is “*9”)

4. Numeric by Grouping (introduced in Gold Client 8.7.4 Patch 3 – 8.7.2024.05)

For a specific range of documents, it will separate the documents by the last two numeric digits grouping and creating a Container for each of them.

Group 1: 00-04

Group 2: 05-09

Group 3: 10-14

…

Group 20: 95-99           

Example:   1234567899 (this entry will be added with all which last digits are between “*95- 99”)  

This diagram shows the Key Split logic for a set of Materials using the Alphanumeric and Alphanumeric by Grouping options (based on the first alphanumeric value): 

 

This diagram shows the Key Split logic for a set of Materials using the Numeric and Numeric by Grouping options (based on the last numeric digit): 

 

Tables using this logic are configured in the Configuration > Data Framework > Additional Tools > Key Split Config

To activate the key split in Gold Client, it is necessary to provide the Table name, Field name and Key split type. The Active/Inactive flag allows to enable/disable the functionality.

 

It is possible to deactivate Export Engine functionality to split table exports into multiple files based on keys in the Configuration > Administration > MConfig

 

Example – Alphanumeric and Alphanumeric by Grouping:

Splitting the export of MARA entries based on material Number – MATNR.

In the case of exporting MM – MATERIAL MASTER using Parallel Processing, for a specific range of documents, it will separate the documents by the first digit and create Containers for each of them.

During the import process, this logic will allow the import of data in parallel to MARA table faster.

Qlik Gold Client Sizing Report for table MARA Export with Key Split inactive

 

Qlik Gold Client Sizing Report for table MARA Export with Key Split Alphanumeric active

 

Qlik Gold Client Sizing Report for table MARA Export with Key Split Alphanumeric by Grouping active 

Example – Numeric and Numeric by Grouping:

Splitting the export of ACDOCA entries based on document Number - BELNR.

In the case of exporting FI - FINANCE DOCUMENTS using Parallel Processing, for a specific range of documents, it will separate the documents by the last digit(s) and create Containers for each of them.

During the import process, this logic will allow the import of data in parallel to ACDOCA table faster.

 Qlik Gold Client Sizing Report for table ACDOCA Export with Key Split inactive

 

Qlik Gold Client Sizing Report for table ACDOCA Export with Key Split Numeric active

 

Qlik Gold Client Sizing Report for table ACDOCA Export with Key Split Numeric by Grouping active

 

Please refer to the Qlik Gold Client Configuration and Utilities - User Guide for more information.

Thanks to Qlik SAP Solutions Engineer Hugo Martins for drafting this content!