lb-domain-transformation

What problem does it solve?

Lab data often arrives in horizontal format where each row is a subject-visit and each column is a lab test. The LB domain requires vertical records, with LBTESTCD, LBTEST, LBORRES, and related fields. This Skill automates detecting orientation, melting horizontal data to vertical SDTM LB format, and applying a robust test-mapping strategy.

Core Features & Use Cases

• Automatic orientation detection: identifies whether input is horizontal or vertical and selects MELT transformation when needed.
• LB mapping and MELT transformation: uses a comprehensive LAB_TEST_CODE_MAP to populate LBTESTCD, LBTEST, LBCAT, and LBORRES fields during the melt.
• Specimen inference & basic data cleaning: infers LBSPEC from domain/category and handles date/epoch fields to populate LBSEQ, VISIT, EPOCH, and LBDTC.
• Use Case: Given a dataset with multiple subjects and visits in a wide format (one row per subject with many test columns), convert to vertical LB format suitable for SDTM submission and downstream validation.

Quick Start

To transform a horizontal LB dataset, run the lb-domain-transformation skill to melt the data and generate vertical LB records ready for SDTM alignment.