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

[Heena]

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

[marcus_malinow · Accepted solution]

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

[Heena]

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]

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