My main task is to upload multiple files in a table. The source files doesn't contain headers and once I configure it on source editor, the column names both in input and output columns are empty (see picture below)
The table consists of 16 columns so I had to manually configure it on the output column to properly map it. It wouldn't be much of a problem to me to do it manually if I only need to do it once. The hard part is I need to upload 12 files for a year (monthly data) and 4 years total.
Any help would very much be appreciated. Thanks in advance.