profile_sector() fails to handle case "b"

[Tilmon]

• Refers to the case where clustered is "b" in the reprex we used to check this issue was fixed: sector_profile() now accounts for unmatched type, sector or subsector tiltIndicator#739
• Relates to profile_sector() fails to handle case "c" #279.

This reprex shows the output of tiltIndicator is as expected but not tiltIndicatorAfter.

---

(Original)

Dear @maurolepore ,

I detected another case of NAs that seems to not be preserved in sector_profile(). That is the case where clustered == b in this reprex. I.e., in the sector_profile product-level output you shared, the output lacks those ep_product that don't have any results because they miss the tilt_sector.

I detected a few examples by comparing results from emission_profile and sector_profile. One example is the companies_id == "%ef%bb%bfmathias-maschinenhandel-laserservice_00000005053892-001"

You can see in the two screenshots below that in the emission_profile() the company contains 7 ep_products, but in sector_profile only 1.

Emission Profile

Sector Profile

Note: The ep_products without any results should be preserved on product-level for sector_profile(), similar as it's done for emission_profile().

The data sources I'm referring to are the product-level outputs from Release v0.0.0.9003