CJA Find and Replace for 30+ values

[KirkBe1]

I have about 30+ values in French and I want to convert them to English for the report.

The translation is done I just need the ability to do a Find and Replace on mass. 

Have tried the Find and Replace within the derived fields but it only supports 5 arguments.

Need something like a big look-up table or something.

I could use classifications but looking for a little simpler solution.  

[Jennifer_Dungan]

I don't have CJA, but that doesn't sound fun... while "derived fields" seems to be the general answer, it seems that it's really only good at a low scale... 

While it won't help historically, in AA I default the main identifiers of content to one language (for our needs English). I then have a "language" dimension that will track if the page was in "french" or "english"... and sometimes I will also dedicate additional dimensions to storing the alternate language(s).

It might be worth investigating alternate tracking like this if the derived fields have those limitations...

However, maybe someone with CJA has some ideas to address your current situation.

Good luck!

[KirkBe1]

Thank you for the reply. 

[Harveer_SinghGi1]

Hi @KirkBe1 ,

The two available options are,

1. Classify function which allows 200 arguments per function and you can use five functions per derived field so in total you can classify upto 1000 keys.

2. Lookup Dataset can be used for large number of keys

Cheers!

[KirkBe1]

Thanks so much, that worked. 

[SamuelPaulPeter]

There are two ways to achieve this!

Classify() in a Derived Field (perfect for 30 values)
Create a new derived dimension, e.g. Page Name (EN) and use Classify() on your French dimension:

- In Derived Field → use Classify()

- Add your French → English pairs (it supports up to 200 per function, 5 functions per field)

- Use an ELSE original_value-style fallback for unmapped values.

This gives you a clean English dimension without touching source data.

Lookup Dataset (best if this list will grow)
If you have the translations in a table already:

- Create a small lookup dataset: fr_value, en_value

- Join it in your CJA connection on the French field

- Use a Lookup() function in a derived field to fetch the English value.

This acts like a big lookup table and is much easier to maintain than editing the derived field each time.

[KirkBe1]

This is very helpful. ty