Link Two Separate Tables Into One Excel For Mac

I have two named tables on separate Excel worksheets in the same Excel 2010 workbook. These tables contain the exact same header items. I could get the results I want by copying the data from one of the tables, pasting it at the bottom of the other and then making a pivot table off of that. If you have multiple data tables, repeat Step 3. If the inputs are the same, link to the same cell(s) as the previous data table you just step up. Change B1 and B2 formula to =””. The cells should look “empty” or blank. Now is the time to link the two sheets together. Go back to Sheet1.

For a new report that will compare data in one market vs another, I need to link two sets of data. I have one excel file with facts and dimensions in it, the date level is month. The other data set is a fact table with date (day level), country and ID fields that link to files with shop, product and productgroup data. So this a small star schema that needs to link to an excel file. First thing I did was to create a date field on day level for the excel file data in the script, so the dates are on the same granular level.

Then a link between the files has to be created. The common level on which both files are unique is for date and brand_type. From these two variables a unique key could be generated. This is as far as I have been able to solve this. After reading all posts on linking tables, making joins, applymap variable, and the generic keys PDF file on this site, I don't get any closer to a solution. Can someone explain how to do this step by step, as I don't understand the process in Qlikview, and how to use applymap or do the data modeling for this.

Hi As far as I can see, one table contains sales facts, and the other contains dimensional information around sales. I would try to see if they can be merged into a single fact table (within a star schema). This may require some analysis of the data (possibly beyond the scope of this forum) and some transformation of the data in one or both of the tables. Linking in the way you seem to be thinking would complicate the expressions in your model and quite probably impair performance. It can also affect accuracy due to problems like double counting errors. Regards Jonathan. Hi It really is hard to say without a proper analysis of the data.

Possibly some combination of ProductGroup, Brand, Type etc relating to productid or unique_name. Quicktime for mac os x 10.4.11 free download. Or perhaps a mapping table (manual or from your sales/ERP system). Anyway, you need some data that associates the sales facts in dataset1 with the dimensions from dataset2. These are some thoughts on your problem (while I am waiting for a long reload to complete.): • What is the unique identifier in dataset1 (ie some combination of fields that uniquely identify records in dataset1)? • What is the unique identifier in dataset2?

Is the timestamp a proper date? • Looking at the data manually, can you see which shopid (and/or unique_name or productid) corresponds to a sales fact? If you can't figure this out manually, then it will not be possible to automate it.

• You describe dataset 2 as a star schema, but I assume it is a single table. You could break that into separate dimension tables, by eg: ProductGroups: LOAD Distinct unique_name, Productgroup Resident dataset2.and similar for the other dimensions. If you really dont know how to go about this, you might need to engage a business analyst or a qlikview consultant to assist you.