topic Re: Concatenating two fields, giving rise to App performance issue or slow in QlikView

Concatenating two fields, giving rise to App performance issue or slow

Heena — Sat, 16 Nov 2024 02:50:49 GMT

Hi,

I am concatenating two fields, ‘Field_A’ & ‘Field_B’ as ‘Field_C’ in script.

The file size increased when I do this, as both fields have 45 million records/rows each.

The App performance also decreased, app became slow.

App size is 1 GB.

Please help me, in any alternative to this?

Thanks in Advance!

Regards,

Heena Kauser

Re: Concatenating two fields, giving rise to App performance issue or slow

marcus_malinow — Thu, 01 Aug 2019 08:31:11 GMT

Hi Heena,

If your fields are large, or have high cardinality this is expected.

What is your reason for doing this? If for example it's because you are creating a composite key you could try using Autonumber.

Marcus

Re: Concatenating two fields, giving rise to App performance issue or slow

Heena — Thu, 01 Aug 2019 11:05:33 GMT

Hi Marcus,

The Reason: to get unique key out of those two fields.

Thanks for your suggestion, working on it 🙂

Thanks & Regards,

Heena Kauser

Re: Concatenating two fields, giving rise to App performance issue or slow

marcus_malinow — Thu, 01 Aug 2019 12:22:28 GMT

Thought that might be the reason, in which case I'd suggest including a delimiter between your two fields in order to avoid possible linking issues.

For example

FieldA	FieldB	FieldA & FieldB as FieldC	FieldA & '\|' & FieldB as FieldC
01	010	01010	01\|010
010	10	01010	010\|10

In this admittedly trivial example a straight concatenation of FieldA and FieldB results in keys which clash. Inserting a delimiter character between them eliminates this possibility