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 ?

Data Investigation

Accepted answers

fmvizcaino

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

2019-12-03 Basic Data Profiling Tool Summary by group.yxmc

2019-12-03 Basic Data Profiling Tool Summary by group.yxmd

All comments

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/ta-p/488165

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

2019-12-03 Basic Data Profiling Tool Summary by group.yxmd

2019-12-03 Basic Data Profiling Tool Summary by group.yxmc

tjamal1

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

fmvizcaino

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

2019-12-03 Basic Data Profiling Tool Summary by group.yxmc

2019-12-03 Basic Data Profiling Tool Summary by group.yxmd

tjamal1

Thank you.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335