Data Transformation Prompt

Transform the following data from {{source_format}} to {{target_format}}.\n\nInput data:\n{{input_data}}\n\nTransformation rules:\n{{transformation_rules}}\n\nProcess:\n1. Parse the input data and identify all fields\n2. Apply each transformation rule in order\n3. Validate the output matches the target format\n4. Report any data that could not be transformed (with reasons)\n\nOutput requirements:\n- Return the transformed data in the target format\n- Include a transformation log: [field] [original] [transformed] [rule applied]\n- Flag any values that required assumptions or best-guess interpretation\n- Count: total records, successfully transformed, failed, skipped\n\nIf any transformation rule is ambiguous, state your interpretation before applying it.