I need some help preparing a directory of data that I’m importing. I’m importing multiple .xlsx files with the Wildcard XLSX Input tool and the I need the first 5 lines of each file made into their own columns. The thing I’m having trouble with is that I have a process that can do what I want it to do for one file, but it then applies the columns to every row in the output, when I need it to apply the correct webinar title and date to the respective webinar. The input tool I’m using is giving each files’ columns a resetting record ID starting at 0. I need these reports to be merged together.
