Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
razorwind
Contributor
Contributor

Mapping load in QlikSense does not work when the "lookup" list is a mixture of numbers and strings.

I just noticed this happened in a recent update, that mapping load does not work it used to? 

Link to demo QVF, you can download this to check out the scenario.

 

Assume we have a list of transactions,  the SKU field contains things like:

A

B

C

D

E

11

22

33

44

55

 

And we want to apply map to another reference table:

A: Letter1

B:Letter2

11:Number1

22: Number1

etc

 

Three ways to do this:

1) Leave the fields untouch, import and load as is

2) Convert the SKU field to text with text() at the load statement

3) Convert the field inside the apply map statement.,


Applymap('SKU to Type',"SKU.Original",'Not Found') as [Mapped Type-Original],

Applymap('SKU to Type',"SKU.Text",'Not Found') as [Mapped Type-Text],

Applymap('SKU to Type',text("SKU.Original"),'Not Found') as [Mapped Type-ConvertApplyMap]

 

1) doesnt work as expected

2) Works

3) Used to work, now does not work anymore. 

 

My questions:

1) Anyone faced this issue?

2) Is my understanding of the issue correct?

3) Bug? Or Feature?

Labels (3)
1 Reply
razorwind
Contributor
Contributor
Author

Attaching the excel file used