topic Re: Look up field value from another table in App Development

Look up field value from another table

Newbie777 — Fri, 16 Jul 2021 05:17:44 GMT

Hello,

I'd like to lookup a field from another table, but I am not sure how I can use Lookup() function. I found out the syntax, but do I have to enter that in the load script?

Do I have to just write lookup() and the syntax, or do I have to write something else? Also, if possible, I'd like to do that in calculated field rather than the load script as I come from Excel background, and calculated field seems easier for me.

Thank you for your help.

Re: Look up field value from another table

tresB — Fri, 16 Jul 2021 07:24:17 GMT

Try with Applymap() instead.

Re: Look up field value from another table

Newbie777 — Fri, 16 Jul 2021 07:33:57 GMT

Thanks for your reply. Can I use Applymap() in the calculated field or do I have to do it in load script which I find it still a little intimidating as I might break some automatically generated codes.

Re: Look up field value from another table

tresB — Fri, 16 Jul 2021 07:43:27 GMT

Are these table associated? Could you explain with a sample app or data set?

Re: Look up field value from another table

Newbie777 — Fri, 16 Jul 2021 09:39:59 GMT

Thanks for getting back again. These tables are not associated because if I associate them, the calculations gets messed up; therefore, they need to remain disconnected tables in order for the calculation to work.

Re: Look up field value from another table

Kushal_Chawda — Fri, 16 Jul 2021 10:37:09 GMT

@Newbie777 There might be various approach to handle this scenario depending on requirements. Would you be able to share sample data with expected output?

Re: Look up field value from another table

Newbie777 — Fri, 16 Jul 2021 13:30:56 GMT

Thanks for getting back again. As shown below, I'd like to keep the two tables disconnected between Employee table and Customer table as associating these will mess up the calculation in other areas with other fact tables.

I'd like to have the name of sales reps from the employee database using 'Sales Rep' field in the Customer table and 'Salesman code' in the Employee table as the identifying keys. I attach the sample dummy data file as an example.

Thanks for your help.