Supplier Coding

[Anonymous]

Hi Everyone,

Just wondered if anyone could help please.

I have a report that I run in Excel which I have a coding sheet to enable me to work out which Supplier a reference relates too.

When the supplier sends in their invoices they us part of their code followed by other numbers and characters.

In excel I am able to work this out by removing characters and vlookups. 

Does anyone know how best to approach this in Qlik View.

I have enclosed some examples on the attached.

Many Thanks

Kind Regards

Wendy