I am attempting to achieve a specified data format for a bill of material conversion file with many many bills. I thought that QV would be an excellent tool to get the load file formatted correctly since there are a lot of BOMs. Essentially, I am looking to take a file with the header and details in one place and break it out with a new column: H/D - 'H' for header and 'D' for detail. The data will appear in a "one off" style as shown in the "Desired Format" tab. I have attached an example excel sheet with what we want to achieve:
1. Use the data found in the "Data to be used" tab to load into QV
2. Use scripting to get the file in the format found in the "Desired Format" tab
Please let me know if anything is unclear and your help is greatly appreciated. I tried:
1. loading table with distinct "header" details and concatenating line items with IF() logic to null values out where needed
This is exactly what we were trying to do. Our code looked similar up until the final load in your script. Thanks a ton. If I may ask one more question: the chart that you used is a straight table, is there any particular thing I need to look out for if we use a tablebox instead?