Skip to Content
0
Former Member
Apr 18, 2011 at 07:48 PM

Add Command question

18 Views

To forum participants,

I need to take a data file and construct a table. The data file is written out in one long record format, see example below.

Property ID Year Batch Base01 Penalty01 Interest01 Base02 Penalty02 Interest02 Base03 Penalty03 Interest03

1234 2009 abcd 500.00 50.00 25.00 300.00 30.00 15.00 600.00 60.00 30.00

Property ID Year Batch # Base Tax Penalty Interest

1234 2009 abcd 500.00 50.00 25.00

1234 2009 abcd 300.00 30.00 15.00

1234 2009 abcd 600.00 60.00 30.00

I need to create a table like the one above. I was hoping that this would be possible through the Add Command feature. Any help would be greatly appreciated.

Bdecker