Hi all - I'm having qlik problems with a common field between several tables and naturally I googled the issue as it seemed counter-intuitive for my having to write a join myself - and found articles similar to these: Don't join - use Applymap instead
Which are excellent! Except I'm unsure of the correct syntax since I've imported an sql file and the tutorials I've seen does not account for that.
However since the user is a common field, qlik is calling some ambiguous loop error and causing me issues when I try connect user to company (and activity).
With Applymap I've done:
Mapping Load UserID, UserName;
select ID as UserID, Name as UserName
ApplyMap('MapUserNametoCompany', UserID, null()) as UserName;
SELECT ID as CompanyID, CountryID, Name as CompanyName
But of course it complains that there is no common field of UserID in the Company table (which is the whole reason I'm looking for an alternative to a join in the first place), which I understand, but am I'm a little confused as to how to apply ApplyMap now.
In these situations how would you handle this? If ApplyMap is the solution could you please explain to me how (without attaching files as I'm using the trial version for my first project) and I would be eternally grateful.