Hello, I have a data set that I'm having trouble with. My returned value for feet and inches is 10'11 as a string. Our salespeople get paid per foot, so I need to turn that into a number that I can plug into a mathematical equation. How can set up Qlik or SQL to convert?
There is no guarantee that there will be inches attached to the length, much of the time it is only shown in feet, but the ' is always in place.
I thought about truncating, but we could have anything from 8 feet up to 150 feet.
Here's my current query.
cl.name as clname,
bsc.name as customer,
left outer join bsc_commissions
on bsc.id = bsc_commissions.bsc_id
left outer join cl
on bsc_commissions.commissionedsalesperson = cl.cl_id