Forum Discussion
Extracting date from poor source data format
Hi all, I have a live query to an SQL server returning some finance fields and the source data is as per table below. B_Jan, B_Feb, B_Mar are the amounts invoiced to a customer in a given month. ...
Do what Mike says, then
You can unpivot the data and convert it to your needs
select the first 2 columns and then select "unpivot other columns"
Split the attribute column in the "_" character
replace b with billing
replace c with cost
rename columns
this gives a data table that is more usable. Does this make sense?
Thanks guys. I get the concept, I'll have a play with the unpivot feature and see what I can come up with. Much appreciated