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

[ishwarappa]

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

[DavidP · Accepted solution]

Here's one way of doing it

[ddiesel]

+1 to @DavidP's suggestion

[ishwarappa]

Hi

Thank you very much for the kind reply.

It solved my problem.

Regards

Ishwarappa

[Pia]

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