Skip to content

    • Archive

    Archive

    Transforms in workbench

    Member
    in Archive

    Hello Admin,

     

    Can you please let me know what is the difference between transforms in the workbench and the one being applied at the tranformation level in the dataflow?

     

    Thanks,

    Bharti

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Comments

    • Member

      Hi,

      Is anyone able to help out with this request?


      Thanks

    • Contributor

      Hi, 

      Transforms in the workbench only have limited (of which some you may not be able to do in a dataflow) features like formatting a date field, encrypting the data for some users etc. 

      Whereas transformations in a dataflow can manipulate the data like in sql which can include changing the format of date, making some calculations and creating new fields, selecting a subset of the dataset etc.

       

      hope this helps,

    • Contributor

      The other key differences I see worth noting are:

       

      Workbench requires your PC to do he crunching

      Workbench does not have a 10000 duplicates limit when doing lookups / joins

      Workbench is quite clunky in general 

       

    This discussion has been closed.

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories