Using several Flat Files for one chart

Jochen

Hi guys,

Iam currently having 7 reports that are using one Flat File (.csv) for several charts.
Due to new requirements I have to use 4 Flat Files (.csv) in these reports.
All 4 Flat Files have the same data column types.

Sounds easy but each chart in all reports needs the data of all 4 flat files.
I know that there are Joint Data Sets but in my opinion it seems kinda awkward to solve this problem with these Joint Data Sets for 4 Flat Files, because the solution would most likely look like this:

Data Set A using Flat File a
Data Set B using Flat File b
Data Set C using Flat File c
Data Set D using Flat File d
Joint Data Set 1. from Data Set A + B
Joint Data Set 2. from Data Set C + D
Joint Data Set from Joint Data Set 1. + 2.

Beside its unhandy solution, my major problem is that I need to do this for 7 reports in total which seems to be a huge time investment.

That's why Iam looking for a more efficient solution.

Can anybody help me please?

Best regards
Jochen

thuston

The more efficient solution is to have your company use a real database and stop punishing you with CSVs.
Every Enterprise database I've dealt with even has a simple UI to easily load CSVs into Tables.