Split an e-mail into Multiple Columns

   tFixedFlowInput allows us to generate fixed flow from many input ways.

   tFixedFlowInput generates as many lines and columns. 

   tFixedFlowInput allows us to generate fixed flow from internal variables.

   This component can be used as a start or intermediate component and thus requires an

output component.

    From the three options, we can select the mode that we want to use.

Use Single Table : Enter the data that we want to generate in the relevant value

field.

Use Inline Table : Add the row(s) that we want to generate.

Use Inline Content : Enter the data that we want to generate, separated by the

separators that we have already defined in the Row and Field Separator fields.

           String values must be given inside the double quotes. Click on the edit schema and give the column name to be passed to the next component. 

          tExtractDelimitedFields extracts values from a single column and place them into multiple fields. Here, based on the field separator "@", it splits the field named 'Mail' into two other fields named as name and web.

                              Output:

Thanks a lot for reading and Please visit again.