Hi I have a template with multiple columns of data forecasting for 30 months, each line has 12 text columns used to describe the transaction then there could be up to 30 number entries in the month columns.
Can I use Flowheater to import to Access and combine the 30 Month columns into one, each value would have to have an individual line and be identified by which column it was entered in i.e Column "201112 with value of 100" would need to be split into 2 columns with one showing "201112" and the other "100" also each line would have to have the Descriptive columns repeated.
I hope this makes sense.
Accounting_Period) This Script gets from the
(with GroupOut option) one Input Parameter. With this parameter the script generates the output Date string. This is necessary because there´s no way to get the field header name
Volume) This Script gets also one input parameter form a AutoID Heater (with GroupOut option) and 12 more parameters - the months fields from the certain year. Note: You have to use the right input order.
I've made a brief example how you can do that. Hope this helps?
Attachment Normalise_Excel_Data.zip not found
Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.