Hello,
So I am loading historical data into tables in TX created of Excel files. One file for property data, one file for casualty data. After some time the file format changes and they combine these two separate files into one file and add new fields.
Can I create a new data source to load the new file but still use the original worksheet tab names such that the data will still load into the existing tables?
Thanks in advance.
P.S. I am using Discovery Hub 17.12.13.64
Hi Keith,
Thanks for posting.
Yes, you can do this by adding the new file as an additional data source, then mapping this new data source table into the same table in the Data Warehouse. This lecture in the online training explains this topic in detail.
Since this is actually asking about the "merging" of two tables, rather than the data sources themselves, I will move the post into the appropriate section: Data modeling & Transformation.
Hi Cathie, here is where this topic is covered in the new course:
Exercise: Add Related Records (Superbikes) | TimeXtender Academy
I would like to combine yearly data from multiple files into one table. I would like to only have one table in the DSA - rather than have one table per year as I have in the ODX. Is that a viable option?
Thanks
Hi Cathie,
Yes, you simply map each identical ODX table into the same table in the DSA. This will create a UNION of all the records from each source table.
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
