topic Re: ApplyMap question in App Development

ApplyMap question

agbcn — Fri, 25 Sep 2020 16:56:06 GMT

Hi,

I just created a new field in one of my tables as a result of an ApplyMap():

ApplyMap('Company_Country', IdCompany) as IdCountry which works OK. As a result, I get a new column in my table named IdCountry which keeps the country of the company.

When I try to use that new field in an ApplyMap() (for instance to get the continent), an error shows up claiming IdCountry is not found:

ApplyMap('Company_Continent',IdCountry ) as IdContinent,
ApplyMap('Company_Continent_Name',IdCountry) as ContinentName,

One workaround could be the following:

ApplyMap('Company_Continent', ApplyMap('Company_Country', IdCompany)) as IdContinent,
ApplyMap('Company_Continent_Name', ApplyMap('Company_Country', IdCompany)) as ContinentName,

What am I doing wrong?

Thanks for your help

Àlex

Re: ApplyMap question

sunny_talwar — Fri, 25 Sep 2020 17:50:39 GMT

Are you doing this in the same load? or is this in a load statement (resident or precedent load) after idCountry has been created? The same load doesn't work, because the field is still getting created and you cannot refer to the field being created in the same load (at least not for this scenario).

Re: ApplyMap question

agbcn — Fri, 25 Sep 2020 17:54:16 GMT

Hi @sunny_talwar

Thanks for your quick reply!

I'm doing this in the same table load, so I guess I should use a temporary table instead.

Regards,

àlex

Re: ApplyMap question

sunny_talwar — Fri, 25 Sep 2020 18:16:22 GMT

You can use a temporary table or you can use Preceding LOAD

Re: ApplyMap question

agbcn — Sat, 26 Sep 2020 11:16:36 GMT

Thanks! I'm gonna try Preceding Load