Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Heena
New Contributor III

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

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

1 Solution

Accepted Solutions
marcus_malinow
Valued Contributor III

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

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

View solution in original post

3 Replies
marcus_malinow
Valued Contributor III

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

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

View solution in original post

Heena
New Contributor III

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

Hi Marcus,

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

Thanks for your suggestion, working on it 🙂

 

Thanks & Regards,

Heena Kauser

marcus_malinow
Valued Contributor III

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

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

FieldAFieldBFieldA & FieldB as FieldCFieldA & '|' & FieldB as FieldC
010100101001|010
0101001010010|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