topic Re: How to paste values from one range into another? in Alteryx Designer Desktop Discussions

How to paste values from one range into another?

armkraftiga — Thu, 14 Jul 2022 18:01:43 GMT

I have a very poorly formatted data set where date is presented as a row instead of a column:

Basically, I want to cut and paste all the values from row 2 into row 1, starting with "Field_6". The data set is updated daily, so I need the range to start at column 2 but continue on indefinitely, see current end of the range:

EDIT: added input sample file

EDIT 2: added "desired output" sample file

Re: How to paste values from one range into another?

dinesha — Thu, 14 Jul 2022 15:15:26 GMT

please post data set

regards

dinesha

Re: How to paste values from one range into another?

michelle_mathews — Thu, 14 Jul 2022 16:42:42 GMT

Hi @armkraftiga , I'm not sure I fully understand but sounds like you could accomplish this with the Select Records tool to separate out your date row from the rest of your data. Then you could use a Union to re-append the data in whatever manner you wish (choose option 'Manually Configure Fields' if you need to position the data in a specific way)

Re: How to paste values from one range into another?

armkraftiga — Thu, 14 Jul 2022 17:57:14 GMT

Appreciate the reply; unfortunately that does not seem to work for me because I need the dates to be recognized as headers for when I use the Transpose tool; otherwise the numbers that appear in the rows below (scroll all the way to the right in the input file) will end up in the same column as the dates.

I will add an output example file to show what I'm trying to get Designer to do.

Re: How to paste values from one range into another?

Emmanuel_G — Fri, 15 Jul 2022 10:41:07 GMT

Hi @armkraftiga ,

See attached one way to achieve this easily.