referralnum as "Referral Number",
acctno & '-' & patno & '-' & Ordering Provider Code as "Patient Key",
status as "Referral Status",
"type" as "Referral Type",
refer_from as "Ordering Provider Code",
refer_to as "Referred Provider Code", bla bla
Left Join (Referral)
rfocode as "Ordering Provider Code",
rfoname as "Ordering Provider Name",
specialtyno as "Ordering provider Specialty",
speccode as "Ordering Provider Specialty code",
firstname as "Ordering Provider Firstname",
lastname as "Ordering Provider Lastname", bla bla
Above is my code. i am trying to produce a "charge key" in table 1 using the column highlighted after left join in table 2.
I know the concept of load but being new to Qlik I donno where to put it and how exactly to implement it. Can someone please help me with syntax ad two lines of explanations for thorough knowledge?