Is there anyway where we can duplicate the numbers for n rows in a column in alteryx ?

[AIPH123]

Hi All,

Is there anyway we can duplicate the numbers for n rows in a column in alteryx? Below is the screenshot output am expecting.

Br,

Anil

[patrick_digan]

@AIPH123 

The multi-row formula tool should work, create a new field with a formula like: If isempty([Field]) then [Row-1:YourNewField] else [Field] endif

[Jonathan-Sherman · Accepted solution]

Hi @AIPH123,

You'll want to use the multi-row formula here:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[AIPH123]

Hi Patrick,

Thank you for your response.

I have used the below formulae in Formulae tool. But the problem here is the new column " Derived planned calls" is not detecting as a field in the formulae tool

If isempty([Sum_# of Planned Calls]) then [Row-1:Derived Planned Calls] else [Sum_# of Planned Calls] endif

Br,

Anil

[AIPH123]

Thank you Jonathan and Patrick. 

It worked

Br,

Anil