topic Re: Applymap not producing data in QlikView

Applymap not producing data

Anonymous — Thu, 14 Sep 2017 12:31:46 GMT

Hello community,

I'm having some trouble with an Apply map function.

Put simply, I'm trying to add the price of a product on a template, and the price of that product on the web, onto my main transactions table.

The joining field is called 'Order_Join', and I have checked to make sure that they do indeed link up.

However, when I apply the mapping load, the resulting field is showing Order_Join, an alpha-numeric key, rather than the corresponding price data from the Mapping load.

Mapping:

Apply map:

Any help would be appreciated.

Cheers,

Henry

Re: Applymap not producing data

its_anandrjs — Thu, 14 Sep 2017 12:36:31 GMT

Check did you use right tablename in mapping.

Re: Applymap not producing data

its_anandrjs — Thu, 14 Sep 2017 12:37:54 GMT

In the Applymap on the table you have to be same number of fields that you have in Mapping table unless it would not map check please.

Re: Applymap not producing data

swuehl — Thu, 14 Sep 2017 12:39:56 GMT

Can you share a screenshot of a table box with Order_Join, Unit_Price and PK_ORDER fields when you are linking the tables instead of mapping?

Re: Applymap not producing data

prieper — Thu, 14 Sep 2017 12:40:02 GMT

The outcome is an indication that there was not a single match found.

Did you check the field "Order_Join" to have really the contents needed for the mapping, i.e. typically you may need to control for leading 0s in the Product_ID and check, how the weeknumber is shown (1 or 01). Keep in mind that mapping is case-sensitive.

Re: Applymap not producing data

Kushal_Chawda — Thu, 14 Sep 2017 12:46:35 GMT

Make sure that the Order_Join in $(Table2)_TEMP2 table is having matching values that created in Mapping tables

Re: Applymap not producing data

its_anandrjs — Thu, 14 Sep 2017 12:47:31 GMT

Check few of this points.

1. Mapping Load tables will load first and then the that table where its applymap required.

2. Key field in mapping table and also Fact table are using same sequence.

3. First load mapping table and check its output will it give proper or not.

Re: Applymap not producing data

Anonymous — Thu, 14 Sep 2017 12:50:11 GMT

Thanks for your replies guys. I'm just loading the data in without drop statements so I can analyse the results (it's 50 million rows, so please bear with me )

Re: Applymap not producing data

swuehl — Thu, 14 Sep 2017 13:01:42 GMT

Where are you using DROP statements in above script?

Re: Applymap not producing data

prieper — Thu, 14 Sep 2017 13:04:09 GMT

for testing makes sense to use only smaller dataset (two months) ...

Re: Applymap not producing data

Anonymous — Thu, 14 Sep 2017 13:04:32 GMT

One after the Temporary Orders table, and two at the very end of the script to drop the Order table after it's been stored

Re: Applymap not producing data

Anonymous — Thu, 14 Sep 2017 13:05:20 GMT

True, I should have thought of that. It's loaded now anyway. And here's my table box

Re: Applymap not producing data

Anonymous — Thu, 14 Sep 2017 13:10:00 GMT

Here is the original mapping file:

Order_Join definitely corresponds to the main table (unless I'm missing something obvious?) and there is valid data in the unit price field (which is what I'm trying to recover)

Re: Applymap not producing data

Anonymous — Thu, 14 Sep 2017 13:26:12 GMT

Actually, it looks like the only reason this is happening is because I haven't specified the default value for non-matches.

Where a match is found, it does bring it back, as shown below:

Oops, thanks anyway guys!

Re: Applymap not producing data

swuehl — Thu, 14 Sep 2017 13:28:27 GMT

Your table box is showing the result of your mapping table attempt.

I was suggesting to link the tables instead of using the mapping, just as I understood you've done before.

(In other words, remove the MAPPING keyword and concatenate your two Price tables into one, or remove the Description filter. Then load your order table and now your two tables should be linked by Order_Join field)

From your previous screenshot, I can't really tell if the values really match. One table shows other product id range than the other.

Re: Applymap not producing data

swuehl — Thu, 14 Sep 2017 13:29:46 GMT

Ok, that Information piece 'where there is a match, it's working' was missing ...

Good that Qlik is working as designed 😉

Re: Applymap not producing data

Anonymous — Thu, 14 Sep 2017 13:50:14 GMT

Yep, I had no idea that it would default to the key field. Cheers for the help though, we've got some good troubleshooting steps that can be referred back to now