topic Re: Converting an ID number to another via a common string in QlikView

Converting an ID number to another via a common string

AyCe1082 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have a long list of images that are named after an ID number. I am looking to convert those names to a different numbering system used in a different database. Is it possible to convert these IDs to their counterparts by way of a common name?

For example:

ID Source 1 ID Name ID Source 2

12345 Ferrari 56789

images/12345.png would be renamed to images/56789.png and render the same image in the UI.

Re: Converting an ID number to another via a common string

jochem_zw — Mon, 02 Mar 2020 16:20:17 GMT

you can use applymap function

so load the table from the other database (Database2) as a mapping table

MapNewNumber:

Mapping Load
ID Name,
ID Source 2
From Database2;

In the table from DB1 use

Images:
Load
ID Source 1,
ID Name,
'images/' & applymap('MapNewNumber',ID Source 1,'Unknown') &' .png' as NewImageName
from Database1;

Re: Converting an ID number to another via a common string

AyCe1082 — Mon, 02 Mar 2020 16:25:30 GMT

Thanks, I will try that out!