I have an Excel Spreadsheet in which I want to add a Column with the field name BALANCE. (member.xls)
The Balance information comes from a separate QVD file. (Balance.qvd)
MEMBERID is the Key between two tables.
Load both tables and the left join them.
is this the requirement or have I misunderstood?
Thanks Left join works.
Retrieving data ...