Basic Data Profiling Tool Summary by group

[tjamal1]

Can we apply Basic Data Profiling Tool to get the summary by Group 

I have table called 'memberInfo' which has following fields 

FileName

MemberID

MemberName

JoinedData

RedemptionPoints 

I want to apply Basic Data Profiling Tool in a way that output should be group by Each FileName in the "FilleName" Column 

is there anyway to do it ? 

[fmvizcaino]

Hi @tjamal1 ,

Yes, there is a way to do it! 😄

I used a batch macro to accomplish the result you wanted. If you are not familiar with it, please read the fresh and great topic below from @EricWe 

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Getting-Started-with-Batch-Macros/t...

I have written some information in the batch macro and the workflow in order for you to understand what is going now in both.

Let me know if that works for you.

Best,

Fernando Vizcaino

[tjamal1]

Thanks for the reply , 
Can we change this macro for Field Summary Tool ? 

[fmvizcaino · Accepted solution]

Hi @tjamal1 ,

Of course we can! Also we can use both, basic data profiling and summary tool, take a look!

If this is what you are looking for, please mark the answer as correct, if not, let me know 🙂

Best,

Fernando Vizcaino

[tjamal1]

Thank you.