Implemented Longest action of summary tool in alteryx same was developed in Azure data flow?

Question

prashanth nethi 1

Hi,

In Alteryx,there were using summary tool implemented with Longest option.

For the same how we can implement in a Azure Data flow.

Can you please help on this query with solution.

MartinJaffer-MSFT 26,236 Reputation points

2021-04-22T15:51:31.377+00:00

@prashanth nethi did either answer solve your issue? If so, please mark the appropriate one as accepted answer, otherwise let us know how we may better assist.
MartinJaffer-MSFT 26,236 Reputation points

2021-04-23T16:47:16.347+00:00

@prashanth nethi if you found your own solution, could you please share here with the community?

2 answers

MartinJaffer-MSFT 26,236 Reputation points

2021-04-22T15:51:31.377+00:00

@prashanth nethi did either answer solve your issue? If so, please mark the appropriate one as accepted answer, otherwise let us know how we may better assist.
MartinJaffer-MSFT 26,236 Reputation points

2021-04-23T16:47:16.347+00:00

@prashanth nethi if you found your own solution, could you please share here with the community?

Answer 1

MarkKromer-MSFT 5,226 Microsoft Employee Moderator

In the Data Flow data preview pane of each transformation, you'll see a button for "Statistics". That will give you the summary stats for each field.

Alternatively, you can add a Power Activity to your pipeline and use it to view your source summary stats.

Here are some helpful videos to walk through it for you:

Answer 2

Hello @prashanth nethi and welcome to Microsoft Q&A.

I did some digging, and I think you are referring to

Longest: Returns the longest string value of the group.

This would be something like:

Select top 1 mystring from mytable order by length(mystring) descending

In Data Flow, this would look like:

Create Derived Column "Length" defined as length(myStringColumn)
Aggregate, column length as max(Length) , nothing in group by.
Lookup, using the Aggregate stream as Primary Stream, and the Derived Column stream as Lookup Stream, joining Length == Length.