topic Re: ApplyMap with Concatenate fields in App Development

ApplyMap with Concatenate fields

YanivZi — Tue, 04 Apr 2023 06:16:21 GMT

I've tried to concatenate two fields using appymap function in load script, it's not showing error but also not showing the data (null), the code is:

[SugHishuvMapping]:

Mapping

LOAD

SugMas & '|' & SugHishuvNumber AS SugHishuvNumber2,

SugHishuvText

FROM [l*****/SugHishuv.qvd]

(qvd);

ApplyMap ('SugHishuvMapping', @2 &'|'& @110,Null()) AS [SugHishuv-ID2]

Re: ApplyMap with Concatenate fields

MayilVahanan — Tue, 04 Apr 2023 06:26:38 GMT

Verify both has same value or not. If its same, might be, there is empty space in front, we can use Tirm() functionality to remove empty spaces in front and end.

thanks

Re: ApplyMap with Concatenate fields

YanivZi — Tue, 04 Apr 2023 06:34:03 GMT

Thank for your reply, I've tried trimming one field and both but it's still not showing the data

Re: ApplyMap with Concatenate fields

MayilVahanan — Tue, 04 Apr 2023 07:38:17 GMT

Is both field - SugHishuvNumber2 and @2 &'|'& @110 has same values?

Re: ApplyMap with Concatenate fields

YanivZi — Tue, 04 Apr 2023 07:46:21 GMT

Yes, they have the same data.

Re: ApplyMap with Concatenate fields

marcus_sommer — Tue, 04 Apr 2023 12:40:15 GMT

I would say the data aren't matching. You could check this by commenting the mapping-prefix and the applymap-function and loading them as own fields as well as an equally named key - maybe in a parallel test-application. And then a table-box in the UI with the relevant fields will show which data are really there and which one match and which not.