We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to create a column using a single cell's data?

kmiklos1
5 - Atom

Hi! 

I am still getting familiar with using Alteryx and was wondering if there was a way to create an additional column in data set using the period date (202.01) from the report's header.  The example below is what I am trying to get my end results to look like.  

 

Hoping someone might be able to steer me in the right direction! Thanks! :)

 

 

Screenshot 2023-10-12 160833.png

2 REPLIES 2
lwolfie
11 - Bolide

See if this solves your problem.  I separated out the header lines from the actual data.  Then selected the line with the period on it and appended it to the data.

kmiklos1
5 - Atom

Thank you so much!! That worked great! :)

Labels
Top Solution Authors