is it possible to combine flat files and tables of a data base extraction within the same data pool?
To give an example:
- Extract all tables from a data base.
- Add an additional csv-file via file upload, e.g. some additional information to one extracted table.
- Join the csv-file with the table from the database in a transformation task.
I’ve tried this in my training environment but it didn’t work there. I could upload the file, but the table wasn’t visible in the transformation tasks.
Does anybody know if this functionality is supported?