How to copy a specific cell value and show it on all rows

Hi friends

I am new to AlterYX and trying hard to understand the various features of the tool.

I have an assignment to copy a specific cell value and show it on all rows of a new column.

* Please refer attached file for input and output expected in separate sheets.

Appreciate your help.

Regards

Ishwarappa

Sample file_how to copy cell value to all rows.xlsx

Workflow

Accepted answers

Here's one way of doing it

split data.png

split data.yxmd

All comments

Here's one way of doing it

split data.png

split data.yxmd

+1 to @DavidP's suggestion

Hi

Thank you very much for the kind reply.

It solved my problem.

Regards

Ishwarappa

Hello DavidP,

This is a good solotion!

However, when I change the input data from 1 file to all the CSV files in a specific folder, it goes wrong.

Then for all files the field "Current Quarter" is being filled in with the value "2018/Q1", while this should be "2018/Q2" for file 2, and "2018/Q3" for file 3, and so on.

Do you know how this can be changed?

Kind regards,

Pia

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15875

MarqueeCrew 13708

apathetichell 13703