community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Finding Alteryx dataset name

Asteroid

Is there a way to get the Alteryx dataset onto a page of a self created report?  I'd like to have it somewhere on the page say "Source: Q1 2017 Alteryx dataset."   I've poked around and haven't come up with anything yet.  It would have to be dynamic so it wouldn't have to be changed with each dataset update. 

 

Thanks!

 

Brad

Quasar
Quasar

If your dataset is a local file, you can can use the Option "Output File Name as a Field" in your Input tool, and then incorporate that into your report.

 

If you would like to see an example, please provide a workflow that represents your situation.

Asteroid

Well Joe, what I'm looking for is the datasets out of Allocate.  So I create a report of my own design (not using a canned report) and what to have on the sheet what the allocate dataset that was used to give the demographics.  How would I get that allocate dataset like Q1 2017 onto the report I've made?

 

Thank you,

 

Brad

Alteryx Alumni (Retired)

Can you use the Field Info or Allocate Metainfo Tools to join to the reporting stream?  They contain vintage information. See attached.

 

Asteroid

That's what I needed!  Get so used to going to certain tools that sometimes I forget about all the others.   Thank you for the help!

Asteroid

If I have two datasets in the list.  One showing for the first quarter and one showing for the second quarter.  How would I choose the most recent quarter?  Sort by descending gets them in the right order but if I then sample that list which may have more than one dataset in it I get only the number of records I put in to sample.  Not all the records with only the second quarter dataset I'd like...  any ideas?

 

Thank you,

 

Brad

Highlighted
Alteryx Alumni (Retired)

This might get you started. Use Text to Columns on the Dataset name, sort by quarter, use a tile tool to number the incidents of a quarter (newest to oldest) and take the X of each. Ok. Convoluted. Yes. 

Asteroid

I care more that it works than how pretty it is written. This solution will help a lot. Thank you.  

Labels