Summary of steps (time to complete: 5 minutes)
Within a Workflow, create a Pipeline.
Select a Dataset.
Provide a transformation and mapping prompt (copy & paste the following):
Filter the Measures column so it only shows Sales, and then filter the Scenario column to just Budget. Next, split the Product column at the dash (“-”) to make two new columns named SKU_Family and SKU_Number. Change any SKU_Family value of 100 to Colas, and everything else to Non Colas. Then rename SKU_Family to Product Family, and then sum the DATA column by Product Family and Year. Then, finally, sort by Product Family.Upload an output "goal" by uploading a sample output file.
Review a transformation plan and approve it.
Agentically and automatically build a pipeline with all the required transformations and mappings.
