Update Transformations

@JoseRCarvas

Hi — I can make these cell-10 transformation changes cleanly and keep the script re-runnable. Concretely I'll: (1) add a constant column Producer = "Hexion"; (2) derive producer_location and Macro Ship To location as "State, City" (not the full address) — sourcing City/State from dim_customer where fact_profitability doesn't already carry them, joining on the customer / Ship-To key; (3) drop Material_code and Material_name from the final view; (4) output the exact column order you listed: Producer, producer_location, Macro Ship To, Macro Sold To, Macro Ship To location, Business, Volumes, Net sales, Vcm, Net sales USD per MT, VCM USD per MT. Any new dependency (e.g. bringing in dim_customer) I'll wire into the same transformation step so the whole thing still runs end-to-end. To get it right on the first pass, please share the current transformation script and a small sample of fact_profitability + dim_customer. I'll return the edited script plus a before/after of the final view so you can check each column. Comfortable in Python/pandas or SQL — whichever your pipeline uses. 5.0-star on delivered data work; can start today, ~2 days, and I'll run one slice first so you see the output before we finalise.

@innoforgetech

You need the transformation script updated to swap producer address for state-city, add a derived Macro Ship To location, and reorder the final output with any missing columns pulled from dependencies. I've built data transformation pipelines where column mapping and dependency joins were the core work. The same pattern applies here. - Built a Reddit-to-Telegram monitoring workflow in n8n where the logic was restructuring API fields into a specific output format; that's the same kind of conditional column extraction and mapping required for this script update. What this covers: - Modify cell 10 to change producer_location to state-city, add Producer column (Hexion), drop Material_code/name, and reorder columns to the exact sequence listed. - Derive Macro Ship To location from existing fields or join dim_customer if the fact table doesn't already have city and state. - Test with sample data to confirm the script output matches the required structure. Script changes first, then we'll check if a new data source is needed; the test round catches any missing field. Your budget is around INR 3500; I can deliver the core column changes and reorder within that, keeping the dependency addition light. If dim_customer turns out to be a heavy join, we'd scope that as a separate step. I'll start on the script once you confirm whether the fact table already holds the needed city-state fields. Best regards, InnoForgeTech

@Algorista92

Hello, it's a pleasure to connect with you. My name is Matías, and I'm the CEO and founder of MJE Data Consulting, working independently as a freelance Data Scientist and Data Consultant based in Córdoba, Argentina. I can help you implement the requested changes to your transformation process, including updating the logic in transformation cell 10, modifying the output structure, and ensuring the final dataset matches your required column order and business rules. I have experience in data processing, Excel, ETL workflows, data integration, and transforming datasets into consistent, analysis-ready formats. I can update the producer and location fields, add the required **Macro Ship To Location** information, remove unnecessary columns, introduce any additional data dependencies if required, and validate that the final output remains consistent and reliable. My focus is on delivering a clean, maintainable transformation process that is easy to review and extend in the future. I'd be happy to discuss the project with you through Freelancer.com, review the current transformation script and data model, and define the best approach for implementing the requested changes while ensuring the final output meets all your requirements. Best regards, Matías

@SHAHIDULLAHMC

Hello, I have carefully reviewed your project, Excel Transformation Update for Producer and Macro Ship To Logic, and I am confident that my skills and experience align perfectly with your requirements. I can adjust the transformation step so producer_location reflects state and city, add the Macro Ship To location in the same format, and reorder the final columns exactly as specified. Material_code and Material_name will be removed, and a new Producer column populated with Hexion will be added. If additional dependencies such as dim_customer are needed to retrieve city and state, I will integrate them cleanly into the workflow. Once the updated transformation cell is complete, I’ll ensure the script runs smoothly and the final view matches your requested structure. If this direction works for you, I’m ready to begin and can walk through any details before starting. Best regards, Mohammad Shahidullah Chowdhury