Issue Mapping Two Sets of Data

Thu, 26 Feb 2015 09:12:20 GMT

Hi Folks,

We were wondering if someone could help us with this. We have an issue mapping two sets of data to our sales records.

Profit Customer linked	Profit Non Customer Linked	Sales
Product Code	Product Code	Order Date
Order Date	Order Date	Cust Code
Profit Amount	Profit Amount	Product Code
Arrange No	Arrange No	Sales Value
Cust Code		Sales Qty
		RSP

Essentially both profit tables contain the same data except Profit Customer linked contains a customer code.

When we put both into the same table, we had two keys originally (key 1 - Cust Code, p-code and o-date / key 2 – Cust Code, p-code), however we had issues with two keys in one table linking to two keys on another table.

When we had these in two tables (based on the same keys from above) - When we selected one arrange number from one table it would drill down to specific dates and products in the sales table which would then pick up values on the second table.

When we merged the two tables into the sales tables, when we selected a date and product the correct figures appeared however when we selected an arrange number the field such as RSP are not appearing which are actually needed.

Thanks in advance.

Andy

topic Issue Mapping Two Sets of Data in Connectivity & Data Prep

Issue Mapping Two Sets of Data