Hi. I'm trying to build a data source from multipl...
# gooddata-cloud
a
Hi. I'm trying to build a data source from multiple CSV files that all have the same formatting, but the idea is that each subsequent CSV has more data that should be aggregated into what's already there. I see in your docs here https://www.gooddata.com/docs/cloud/connect-data/csv/#UploadCSVFiles-ManagingCSVs that there is a line that says
In the Logical Data Model (LDM), you can link data from multiple CSV files within the same data source.
How do I do that? It isn't obvious to me after poking around the LDM how to make sure additional CSV data is included in the first one. Just adding more CSV files to the data source does not appear to automatically include the new data in the set when I make a visualization. Please advise. Thanks.
m
Hi Adam, if I understand correctly you have updated an existing CSV file / datasource and once updated the new data has been uploaded it is not present in your reports. Is this correct? After making the update, could you please try to “refresh” the datasource in your LDM to see if this helps?
If this is not the case, or if I have misunderstood the issue here, please can you provide more details and we’ll be happy to look into this further for you
a
@Michael Ullock Refreshing didn't make a difference. But I think I see what's happening here. Each CSV within a data source is treated as a separate table in the LDM, so you can't have say 4 CSVs each with the same column format and each with 25% of the total data rows and have them all in one table in the LDM. They can only be 4 separate tables in the LDM. Is my understanding correct here?
m
Hi Adam, sorry for the delay in getting back to you here - But yes, your understanding is correct. Each CSV file in your use-case is treated as a new datasource
1