Transform Data by Example

Example-driven search engine that helps you find functions for your data wrangling task.

Project page (How-to, FAQ, Sample data, and more) | Rate us on Office Store

How can we improve Transform Data by Example?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  1. Corporate controls for transformations

    I can think of lots of uses for this using internal data sources, but I'd like to give users a prepopulated set of transforms to use so they don't have to "discover" them. Also, we'd possibly like to minimize data leakage by blocking access to unapproved transform services.

    3 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)

      We’ll send you updates on this idea

      2 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    • Address what information is sent "over the wire" as part of this feature

      This feature appears to possibly send (or have the ability to send) protected health information (PHI) to Azure over the web. If I am using an address-related feature of Transform Data by Example, is the actual data sent over the wire, or is a computed hash of that data sent over the wire? It would be good to know what is being sent between servers. I like this plugin, but couldn't use it for some sensitive data if that data is sent out over the internet.

      3 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)

        We’ll send you updates on this idea

        1 comment  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
      • Bring this out of the kitchen

        This is a great feature - Dont let is languis in the kitchen like what you did with Fuzzy Lookup
        https://www.microsoft.com/en-in/download/details.aspx?id=15011

        1 vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)

          We’ll send you updates on this idea

          1 comment  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
        • Feature Redundant

          This feature seems redundant as there is a very powerful transform by example feature embedded in Power BI through POwerQuery. I suppose this feature will also soon be available for POwer Query in Excel

          1 vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)

            We’ll send you updates on this idea

            1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
          • Silently Integrate with Flash Fill given certain confidence threshold

            This is a beautiful feature! You could (a) add a HUGE value bump to Flash Fill, and hence add good value to Excel generally and (b) get this in front of WAY more users if you silently integrate this with the Flash Fill feature. Consider leaving the selection of functions to advanced users / v2 UX for flash fill and just surface these suggestions via Flash Fill when a certain confidence threshold is met. This could be a killer productivity feature for many information age workers, but this integration could be huge for getting it in front of the bulk…

            2 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)

              We’ll send you updates on this idea

              1 comment  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
            • 1 vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)

                We’ll send you updates on this idea

                1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
              • Make it available for iPad iOS 10.3

                I added using the store but it does not appear on add-in list

                1 vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  1 comment  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
                • Don't see your idea?

                Transform Data by Example

                Feedback and Knowledge Base