Dynamic Processing

[Tridev_Dev]

Hi, Need to develop a Dynamic workflow, Where input file fields were not constant every time. Its Different from client to client but the output format is constant, For Eg in  First Input file if i have a fields like First Name, Surname, and Full Name but in the second file i have only Full Name. after that need to do logics . Attached a copy of sample Workflow. 

[FrederikE]

Hey @Tridev_Dev,

You could use a Look Up Table to define allowed fields. See the attached example. This will work for your example well.

But you are very unspecific with your requirements -

-How do the files differ and what are the options (are there a limited number of options that can be predefined or are there an infinite amount of options?),

-what kind of data are we talking about (are there common cell characteristics to identify common cells?) 

-Is there a certain order of how the fields are aranged (e.g. you could use the field position instead of the names)

-How many different clients are there?

-Is there any further logic to identify the columns? 

These are a few questions I'd ask myself and hopefully a few helpful tips to find a solution. If you require more help, we need more information and prob. (dummy) data.