Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I can't understand why the following map isn't working. The mapping table has the right data, and the destination table creates the correct field, but it has null values. Any ideas?
DisablityMap:
Mapping Load "adisabil_cde",
"adisabil_dsc" ;
SQL SELECT *
FROM PUB."mis_adisabil";
Disability: LOAD "per_num",
"adisabil_cde",
ApplyMap('DisabilityMap', adisabil_cde, 'NONE') as [Person Disability],
"aperdisabil_str_dat" as [Person Disability Start Date],
"aperdisabil_end_dat" as [Person Disability End Date],
"TimeStamp"
where "aperdisabil_end_dat" > $(vToday) or len ("aperdisabil_end_dat") = 0;
SQL SELECT *
FROM PUB."mis_aperdisabil";
STORE Disability into 10_QVDFiles\Disability.qvd;
Many thanks
Hi
You have a typo in the Mapping table name: DisablityMap. Should be DisabilityMap.
Greatings.
Nicolai
remove the double quotation marks around the field names
i think this is the only reason
make sure too that aperdisabil_end_dat" and $(vToday) have the same format and I think you should use '$(vToday)'
Perhaps the field is not being recognized without quotes. Put proper quotes and try like:
ApplyMap('DisabilityMap', "adisabil_cde", 'NONE') as [Person Disability],
Thanks for the heads up about the $9vToday), I'll look into it.
However, changing the quotation marks around the field name didn't affect the outcome of my initial query.
Thanks
Thanks for the suggestion but it still gives the same result with the changes you suggested.
Hi
You have a typo in the Mapping table name: DisablityMap. Should be DisabilityMap.
Greatings.
Nicolai
Thanks, I'm sure I checked that a million times but words were never my strong point.
Thanks.