in the second table load, you can rename the field id to points that way, you have the correct association. QV will automatically associate the two tables. below is an example, use the correct field names you need and tweak as necessary!
script tab would look like:
(ooxml, embedded labels, table is Points);
id as points,
(ooxml, embedded labels, table is Data);
in a chart (bar or straight table would be best to start off), use dimension as company and expression as
ps: i misunderstood your requirement...you will have to use purgechar as Ajay mentioned.
in that case, join the two tables in the above example by simply writing "join" after first table (Points) load and before second table (Data) load statements and then write the following after joining the tables in script:
compscore*points as Product
drop table Points;