Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
Hello Dave,
Try this,
Table1:
Load
SalesPersonId,
Period,
Sales
From abc;
Concatenate(Table1)
Load
SalesPersonId,
Period,
Ramp%
From xyz;
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%