skills.rest
siddharthchauhan
siddharthchauhanCOMMUNITY
Explore all skills by this author →
GitHub

mapping-specifications

Parses Excel-based SDTM mapping specifications and applies DSL functions to transform source data into SDTM domains.

Updated Aug 27, 2026
Search Tags:#transformation#excel#dsl#clinical-trials#sdtm#mapping-specifications#63-domains
One-click install
npx skills add https://github.com/siddharthchauhan/ETL --skill mapping-specifications
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: mapping-specifications
Source: https://github.com/siddharthchauhan/ETL/tree/main/sdtm_pipeline/deepagents/skills/mapping-specifications
Command: npx skills add https://github.com/siddharthchauhan/ETL --skill mapping-specifications

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

SDTM mapping requires defining transformation rules for 63 SDTM domains, often via complex Excel specifications and a Domain Specific Language. This skill streamlines parsing, validating, and applying those specs to convert source data into SDTM formats.

Core Features & Use Cases

  • Supports parsing Excel-based mapping specifications for all 63 SDTM domains.
  • Provides a declarative DSL with functions like ASSIGN, CONCAT, IF, FORMAT, ISO8601DATEFORMAT for domain transformations.
  • Enables both domain-level and dataset-level transformations, with explicit domain mapping details and output verification.

Quick Start

Load an Excel mapping file, review domain mappings, and run a transform for a target domain (e.g., DM or AE) to produce an SDTM-compliant dataset.

Frequently Asked Questions about mapping-specifications

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate SDTM mapping specifications from an Excel file?▼

Automate SDTM mapping by loading an Excel mapping file into the engine and applying declarative DSL functions like ASSIGN, CONCAT, and IF to transform source data into compliant SDTM domains.

What is the best way to apply domain-specific language transformations for clinical trial SDTM domains?▼

Use a declarative DSL with functions such as FORMAT and ISO8601DATEFORMAT to apply rule-based transformations across all 63 SDTM domains, converting raw clinical trial source data into standard formats.

Can I use Excel mapping files to transform source data into all 63 SDTM domains?▼

Yes, you can parse Excel-based mapping specifications to define and execute domain-level and dataset-level transformations, generating any of the 63 SDTM domains including DM and AE.

How do conditional transformations work when mapping source data to SDTM formats?▼

Conditional transformations use DSL functions like IF and CONCAT within the mapping engine to evaluate source data fields and apply rule-based assignments for generating SDTM-compliant outputs.

What do I need to execute DSL transformations for SDTM mapping?▼

You need an Excel mapping file containing the transformation rules and a mapping engine that interprets DSL functions like ASSIGN, CONCAT, IF, FORMAT, and ISO8601DATEFORMAT to process source data.

Does this approach support both domain-level and dataset-level SDTM transformations?▼

Yes, the DSL mapping engine supports explicit domain-level and dataset-level transformations, allowing detailed rule-based mappings and output verification for individual SDTM domains.

Related Skills

Explore More Data & Analytics Skills→
mark64oswaldmark64oswald
1

healthsim-trialsim

Generate regulatory-grade synthetic clinical trial data across SDTM domains.

Community
Advanced
89jobrien89jobrien
4

web-accessibility

Audit web content for WCAG 2.1/2.2 conformance and accessibility issues.

Community
Advanced
Poom5741Poom5741

frontend-design

Convert design briefs into frontend interfaces with typography, color, and motion directives.

Community
Advanced
DojoGenesisDojoGenesis
2

observability-dashboard-spec

Generate an architectural spec mapping SSE events and OTEL spans to dashboard widgets.

Community
Intermediate