ID and Date Link

[Anonymous]

I have two data sets:

1st data set has SalesPersonId, Period, Sales

2nd data set has SalesPersonId, Period, Ramp%

I am trying to create a graph that tracks Sales and Ramp% for each Salesperson on a graph. I would like to show two lines, per SalesPerson Id, that show Sales and Ramp% over the same PERIOD.

My script is pretty basic, and I just have a synthetic key joining these two sets at the moment, but I am not getting the desired effect.

Any help is appreciated.

- dave

[kkkumar82]

Join the two tables with the common columns in both the tables, it will resolve the synthetic keys, do you have any other columns in both the tables?

[rohitraut]

Hello Dave,

Try this,

Table1:

Load

SalesPersonId,

Period,

Sales

From abc;

Concatenate(Table1)

Load

SalesPersonId,

Period,

Ramp%

From xyz;

[its_anandrjs]

Try to join those tables with the keys that you get in the Synthetic Tables or go for Concatenation.

With JOINS but be careful about the Key fields

Table1:

Load

SalesPersonId, Period, Sales

Join(Table1)

Load SalesPersonId, Period, Ramp%

With Concatenation

Table1:

Load

SalesPersonId, Period, Sales

Concatenate(Table1)

Load SalesPersonId, Period, Ramp%