Introduction
Designer has the ability to automatically join together separate files after they have been synced. Some benefits include:
- Saves time designing: quicker to map a single file than it is to map several files.
- Keeps designs simple
- Helps with incremental data
How it works
- Name your files: Users must name the original raw data files in a particular way for this feature to work. Filenames must start with split_[yourfilename]_ and then you can choose any name you want, as long as it is consistent across all the files you’d like to join. Anything after the second underscore can be whatever you want to distinguish the files from each other.
- Sync: Files must be synced to the same location.
- Auto join: after sync, designer will automatically join all your files together and place the resulting file in the usual spot in Designer, named your filename
- Updates: Feel free to add new raw data files or edit the data in the existing raw data files. Designer will recognise this on Sync, and re-build the joined file.
Example
Step 1
Locate all the raw data files that need to be joined. We are going to use three transaction files: 2015ALL, 2016Q1 and 2016Q2.
Step 2
Rename them by prepending each filename with ‘split_sales_’, as shown:
Step 3
Sync files to a single location.
Step 4
The files will appear individually in designer exactly as you've named them, but you’ll also notice a new file which is named [yourfilename]. (whatever is between the two underscores). In our example it is called Sales. This is the joined file. Use this in your design and you’re good to go.
