Highlighted

Reorder a lookup table

Silver Contributor
Silver Contributor
It looks like the order of a lookup table is important when you're passing an array in as the source and expecting an array out of the lookup table. For example, we have a lookup table that takes ad positions in as an array like ["WX_VideoCompanion","WX_VideoPlayer","WX_Spotlight"]. The elements of the lookup table (because of entry order) has "WX_Spotlight" before "WX_VideoPlayer". This causes the lookup to return [,, "nl"]. The last value is the default value if the lookup can't find a value. Even though the value for WX_Spotlight is in the table, the lookup can't find it, because of the order. The solution is to insure that all values in the lookup table are in alphabetical order and then sort any input array alphabetically. However, as stated before the order in the lookup table is a result of when the entries are made and there seems to be no way to re-order the lookup. Am I missing something?
2 REPLIES 2
Highlighted

Reorder a lookup table

Tealium Employee
You can 'Export to CSV" that gives you a comma-separated value file - From there you can open it up in Excel and use "Data Sort" to alphabetize. Save as a CSV file format. Open up in a simple text editor then copy and paste into "Import from CSV" in TIQ. Select "Replace" to overwrite. One caveat is if you have 'commas' in the values for the 'Match' or 'Output' they will create an error on import, since it is a CSV file make sure any values with commas have double quotes.
Highlighted

Reorder a lookup table

Silver Contributor
Silver Contributor
Thanks. Works like a champ.