hi,
I'd like to collet into one file the metadata information of each field contained in the input file, including the number of values contained, the % of completion.
Is there a way to collect this information?
thank you
Myriam
@msantoso
See example of WF attached. You can create a column to calculate this completion rate.
Cheers,
Hi @msantoso
Yes there is. Data Investigation Tools help you to do that.
https://help.alteryx.com/2018.3/BasicDataProfile.htm
https://help.alteryx.com/2018.2/Field_Summary_Report.htm
https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-Basic-Data-Profile/ta-p/28610
https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-Field-Summary/ta-p/104675
Hi Thableaus
thank you for your quick response.
I did not know these tools! I have put them in my favourite!!
however this is not really what I'd need.
I'd like a table such as the one produced by the basic tool but with a supplementary column showing the completion rate for this field
any chance?
