Discussion Board for collaboration on QlikView Scripting.
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!
Go to Solution.
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.
View solution in original post
The Reason: to get unique key out of those two fields.
Thanks for your suggestion, working on it 🙂
Thanks & Regards,
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.
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