How to add additional information into input file and then save it as an output file

[kauser]

Hello, 

i do have a scenario where i have to add additional information/data into an input file then save that file with new additional information into an output folder location. how can i do that in Alteryx.  

Thank you 

Kauser 

[alexnajm]

@kauser I am not sure I understand the issue - shouldn't it just be Input Data to whatever transformation steps you need to do to an Output Data tool?

[kauser]

Here i illustrate below- 

Input Data- 

Month	Product	Rate	Jan	Feb
January	A	2.5	2,345.00	2,814.00
January	B	3.2	57,858.00	69,429.60
January	C	8	1,232,314.00	1,478,776.80
February	A	4	787.00	944.40
February	B	6.8	7,697.00	9,236.40
February	C	1.2	234.00	280.80
March	A	4	678,768.00	814,521.60
March	B	2.4	34,543.00	41,451.60
March	C	8.9	67,867.00	81,440.40

Expected output within same file and Same sheet - 

you can i have added few new data highlighted in Green. my question is how can i add those new data into input file then save it as an output file. so the recipient can see both input data and output data within same Sheet. 

Month	Product	Rate	Jan	Feb		Row Labels	Sum of Jan	Sum of Feb	Sum of Jan	Sum of Feb	Sum of Jan	Sum of Feb
January	A	2.5	2,345.00	2,814.00		February	787	944.4	7697	9236.4	234	280.8	8718	10461.6
January	B	3.2	57,858.00	69,429.60		1.2					234	280.8	234	280.8
January	C	8	1,232,314.00	1,478,776.80		4	787	944.4					787	944.4
February	A	4	787.00	944.40		6.8			7697	9236.4			7697	9236.4
February	B	6.8	7,697.00	9,236.40		January	2345	2814	57858	69429.6	1232314	1478776.8	1292517	1551020.4
February	C	1.2	234.00	280.80		2.5	2345	2814					2345	2814
March	A	4	678,768.00	814,521.60		3.2			57858	69429.6			57858	69429.6
March	B	2.4	34,543.00	41,451.60		8					1232314	1478776.8	1232314	1478776.8
March	C	8.9	67,867.00	81,440.40		March	678768	814521.6	34543	41451.6	67867	81440.4	781178	937413.6
						2.4			34543	41451.6			34543	41451.6
						4	678768	814521.6					678768	814521.6
						8.9					67867	81440.4	67867	81440.4
						Grand Total	681900	818280	100098	120117.6	1300415	1560498	2082413	2498895.6

[alexnajm · Accepted solution]

So you can do this - input your data, do your transformations to get the second part, join the together (likely on record position), and output to the file of your choice!

Or if its to the exact same file as the input, you can create the new data and output it to a specific range in the same sheet