Skip to Content
0
Former Member
Jun 10, 2011 at 01:52 PM

Split Columns Data to Rows

146 Views

Hi there!

I'm trying to figure out how to split some columns data in to rows. My company has only purchased the Data Quality license of Data Services (3.2) so I'm hoping we can find a way to do this without having to purchase the Integrators license too.

I have 4 columns, and in fact they come from the Address Cleanse suggestion list. Selection, High, Low, Indicator. I want to create rows sequentially based on the number between the high and low. So if the Low is 50 and high is 60, I want to create 10 rows (50,51,52,53,etc), then move on to the next row and do the same. I'm doing it all on memory tables at the moment, and I can't figure out for the life of me how to do this.

Regards,

Matt