Joining two data set

[Sunitha]

Hi All,

Please help in joining 2 data sets.

1. Revenue Budget 2020: Budget data ( which has data for 12 months)
2. Gross to Net Sales 2020: Actual Sales for 2020

Year, Accounting period and Market code are unique keys.

Thanks,

Sunitha Nagalapur

[TomWelgemoed]

Hi @Sunitha ,

Think the attached does it - you do need to create a matching accounting period for the join to work.

NOTE: It looks like there is another join missing, as you're getting duplicates when using the fields mentioned. You just need to add any remaining conditions to the join or ensure the data is unique.

Let me know if you have questions.

Regards,

Tom

[Sunitha]

thank you .Kindly share .yxmd i;m unable to import.

Thanks,

Sunitha

[TomWelgemoed · Accepted solution]

Hi,

Here you go.

I've had a closer look and I think these are some of the additional joins you may be missing:

MPG & Sub Region.

[TomWelgemoed · Accepted solution]

To add, the join is not returning a lot of matches.

I've not had time to investigate that, but you can maybe look at data quality in the fields - or perhaps this is an expected result.

Regards,

Tom

[Sunitha]

Sure Tom. Thanks for help i'm trying to analyse.

thank you so much.