Append the New data into Existing Template file!!!

[Dhilip_Kumar]

Hello All,

I have two files:

1. Master Template - contains formulas and specific formatting.

2. New File - Contains current week data.

I need to copy the data from the New File into the Master Template without affecting the existing formulas or formatting.

I have attached both files for reference. Please advise on the best way to process this, and if possible, a sample workflow would be helpful.

Thanks

Dhilip

[davidskaife]

Hi @Dhilip_Kumar 

Here is an approach that uses the Append to Existing Sheet option on the Output Data tool, however, you'd need to delete all the formula that has carried down for the blank cells otherwise you end up with it appending under this:

It appends on Field Name so as long as your fields are named identically between the files it will work.

As far as i'm aware you will not be able to add the data in while the formula's are dragged down, as Excel considers the bottom of this the 'end' of the data in the file and will always add in anything new after this.

[Dhilip_Kumar]

@davidskaife Thank you. will check and keep you update.

[Dhilip_Kumar]

@davidskaife  Is there a way to update the new data from row 12 since the formula also required to calculate the days.

[davidskaife]

You'll need to remove the formula from row 12 onwards, run Alteryx to populate the data, then drag the formula back down. I don't think you can do it any other way (i.e getting Alteryx to place the data in rows 12 onwards while the formula are there)

[Dhilip_Kumar]

@davidskaife Thank you for your quick response. I am looking for the option to automate the process completely. Is there a way to find the last row of the first filed and update the data into the next row. just thoughts