Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Metadata description of the input file

msantoso
8 - Asteroid

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

7 REPLIES 7
msantoso
8 - Asteroid

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? :)

Thableaus
17 - Castor
17 - Castor

@msantoso

 

By completion rate, you mean (number of non-nulls/number of records) * 100?

 

Cheers,

msantoso
8 - Asteroid

yes exactly :)

 

Thableaus
17 - Castor
17 - Castor

@msantoso

 

See example of WF attached. You can create a column to calculate this completion rate.

Capturar.PNG


Cheers,

 

msantoso
8 - Asteroid

Wonderful !! this is exactly what I needed

 

thank you!

 

msantoso
8 - Asteroid

hi

 

may I ask another favour? 

 

In my WF, I have many input file. 

would it be possible to add the input file name the field is coming from? 

thank you 

Myriam

Labels
Top Solution Authors