Hello,
I have a raw data file that has the report run parameters in the first couple of rows, and the column headers with data after that. Normally, I would just "start import" from the row number that has the column headers.
However, my output needs to look the same as the raw data file - i.e., it needs to show the report parameters on the top, and then the original + computed columns at the bottom (screenshot below).
Currently, I do the following:
- Use the "select" tool to separate the two sections
- Use "Dynamic Rename" and "select column headers from the first row of data" to be able to perform calculations on the part that contains the data
- Output them into specified cells in the same output tab.
Is there a better way to do this? It gets a little complicated when I need to do this multiple times for large amounts of data, or when I need to rename the tab using a formula.
