To add few specific rows

[Polite123]

Hi Experts,

Need some quick help in below dataset 

Need data in below format.Below image is that of excel but need alteryx o/p in similar fashion

	A	B
	1	3
	2	4
	3	5
	6	12
Ammend	2	0
Total	8	12

Thanks in advance:)

[atcodedog05]

Hi @Polite123 

Is there any label for this row

[Polite123]

Nope:

[leon2020]

I'm not sure what you're trying to do.  You can simply cut and paste into a text input tool?

You might add Record ID tool (Preparation tools) to number each row, then use the row number in subsequent formulas (eg. IF rowID=1...).  Then once you've done everything you need to, use the select tool to de-select the record ID.

You might consider populating the blanks with a temporary filling string to replace at the end of the process too - whereas you might want the output to be blank, it might help to have a temporary containing value in there during your process and to reference in your formulas during the calculation part.  You can always add a formula tool at the end to make those cells blank etc at the end of your workflow before output.

[atcodedog05]

Hi @Polite123 

Here is a workflow for the task.

Input:

Output:

Workflow:

Hope this will do

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[Qiu]

@Polite123 

You got to give your input and desired output if you want some help here.🙄

[Qiu]

@atcodedog05 
You are just too nice...

[Polite123]

Hi @atcodedog05 ,

Ammend row is not part of input. It should ne part of output only

[atcodedog05]

Hi @Polite123 

If thats the case how is Ammend calculated.