Template based on a criteria

Hello,

I have 10 different templates that have specific columns depending on the process, could you recommend a workflow that selects the applicable template based on the process column value?

For example:

The input data has several columns and in the column process has SAS then the workflow has to select the SAS template and auto-populate the values for the SAS columns from the input file to this template.

Best,

Mabel

Developer

Output

Custom Tools

Common Use Cases

Transformation

Dynamic Processing

Join

Preparation

Interface Tools

Accepted answers

braveraj

Hi Mabel

Give this workflow a shot. To get this to work you'll want to put your field names for the templates as rows. Its a little more complicated than my original reply but hopefully this addresses your issue.

Adam

Dynamic Template Workflow.yxmd

All comments

braveraj

Hi Mabel

Couple of questions for you. Do all of the input data have standardized field names and start on the same row, or can it vary? Like if a spreadsheet has headers and the data starts on row 5 versus another template starts on row 1.