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
10 - Fireball

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