topic Re: Unable to Map a field from one able to another using applymap in App Development

Unable to Map a field from one able to another using applymap

vishalmanu — Sat, 16 Nov 2024 21:49:46 GMT

Test

Re: Unable to Map a field from one able to another using applymap

vishalmanu — Tue, 02 Feb 2021 07:37:29 GMT

Sorry, forgot to attach another file

Re: Unable to Map a field from one able to another using applymap

rwunderlich — Mon, 26 Nov 2018 20:49:26 GMT

Please post the script that shows where you load the mapping tables and the applymap(). Or post a sample app if you can.

-Rob

Re: Unable to Map a field from one able to another using applymap

vishalmanu — Tue, 02 Feb 2021 07:38:07 GMT

Hello rob,

Please find the below the script that i have used. Kindly note that i have used two apply map functions to check the feasibility of the Applymap functions based on two diff common keys.

Kindly look into this and provide me a solution

Re: Unable to Map a field from one able to another using applymap

Lisa_P — Tue, 27 Nov 2018 04:18:35 GMT

I can't find any matching values in the data.

Re: Unable to Map a field from one able to another using applymap

vishalmanu — Tue, 27 Nov 2018 05:22:40 GMT

Hello Lisa

There are matching values between in the fields productcode from the mapping table to material_key_new in the origin table

Re: Unable to Map a field from one able to another using applymap

Lisa_P — Tue, 27 Nov 2018 06:02:40 GMT

Not sure how it handles mixed formatting in the field

Re: Unable to Map a field from one able to another using applymap

rwunderlich — Tue, 27 Nov 2018 19:06:34 GMT

material_key_new is an existing field in the QVD?

Re: Unable to Map a field from one able to another using applymap

vishalmanu — Tue, 27 Nov 2018 19:07:43 GMT

Yes. It already exists

Re: Unable to Map a field from one able to another using applymap

CarlosAMonroy — Tue, 27 Nov 2018 20:15:21 GMT

Hey Vishalmanu,

I did not download your sample files, but if you're trying to map 'Dates', it's important that you make sure both date formats from source to target table are the same. If you are getting nulls values, this could be the reason.

Thanks,

Carlos M

Re: Unable to Map a field from one able to another using applymap

vishalmanu — Tue, 27 Nov 2018 21:37:03 GMT

Hello Carlos

Thanks for your solution. However I am trying to get the date field from the mapping table to the original table base on the common key which is the product code(not a date field).

Thanks

Re: Unable to Map a field from one able to another using applymap

CarlosAMonroy — Tue, 27 Nov 2018 22:02:37 GMT

Well that applies for any field, sometimes you have to specify if it's a number or text.

Then you should be fine by just following the Mapping structure:

SourceTable:
Load Mapping
KeyFieldSourceTable,
FieldToMap
From SourceTable;

TargetTable:
Load
ApplyMap('SourceTable', KeyFieldTargetTable) as KeyField,
Field1,
Field2
From TargetTable;

That should do it. Hope that helps,

Carlos M

Re: Unable to Map a field from one able to another using applymap

vishalmanu — Tue, 27 Nov 2018 22:10:10 GMT

Thanks for the another solution Carlos. I have tried to use the text() function for the common fields (Productcode and Mterisl_key_new) from both the tables so that they resemble the same values. Yet I did not succeed.

Re: Unable to Map a field from one able to another using applymap

rwunderlich — Tue, 27 Nov 2018 22:23:03 GMT

My suggestion would be to load the mapping file as a regular (non-mapping) table, naming the key field to be the same as the fact table field. ANd then see what matches up or why not.

-Rob

Re: Unable to Map a field from one able to another using applymap

CarlosAMonroy — Tue, 27 Nov 2018 22:39:33 GMT

You can try what Rob said. Would be easy if you share just the script for the map (Source and Target tables). We can see if there is any syntax error, or format issue.

Thanks,
Carlos

Re: Unable to Map a field from one able to another using applymap

Anil_Babu_Samineni — Thu, 29 Nov 2018 07:17:14 GMT

I didn't see any common field from 2 tables?

I mean this? Until unless you can't get that work using Applymap.