I'm running into trouble with the Apply Map function. The data that is being pulled into the Apply Map is not matching what is in the original QVD. For example, in my Site.qvd I have two rows, SiteId and SourceData - SiteId is an Id filed and SourceData is a value. When I use the ApplyMap function below, the Id field is returned. Can some explain what I'm doing wrong?
Here is my script.
FROM [lib://Development Final Transformed Data/Site.qvd]
SourceData & '-' & SiteId as SiteKey,
SourceData & '-' & "UserId" as UserKey;
ID as OrderId,
ApplyMap('SiteSourceMap', SiteId) as SourceData,
FROM [lib://Development Raw Managed Data/Order_Order.qvd]