Append rows to the output file

Hello All,

I have an output file that has multiple sheets and in one of the sheets I am appending rows from an input file based on only one column. For eg...I am appending column A - account number and rest of the columns are formula based so once the data is appended in column A,,,other columns like B,C ,D will auto populate based on column A.

However the data is not getting appended exactly below the previous row. for eg if in the sheet the previou row was in row nuber 10, I am expecting the data to be appended from row 11 however it is not getting appended in row 11 however in some vague row like 15000.

Coud you please help me with this.

Developer

Accepted answers

All comments

Jean-Balteryx

Hi @mihir_mir_jb ,

Can you share your workflow ?

Jean-Balteryx

As your columns after the A one are formula based, have you extended your formulas after your last row of data in your file ?

mihir_mir_jb

Yes, I have extended the formula after the last row of the data.

In the attached untitled.png file you can see that my last row was ending on row 1619 also the formula has been dragged after row 1619, however if you notice in capture.png file the new records are appended from rows 45761 instead of 1620.

Can you provide the sample input and destination output files.

Jean-Balteryx

By any chance, are your formulas extended up to row 45760 ? I suspect that is the case so Alteryx consider those rows as populated and it appends from here.

mihir_mir_jb

@Jean-Balteryx no the formulas are not extended up to row 45760

Jean-Balteryx

Can you share your your data files ?

HomesickSurfer

Hi @mihir_mir_jb

Your Excel file has formatting or some remnants of previous data in the rows beyond your 'true' data.

You can confirm that in your file with 'Ctrl' + 'End'.

Consider formatting your Excel data as a table with a defined named range, then output to the named range, complete with field mapping.

Alternatively, read in all NonNull/Non-blank, Non-Empty rows, union them with your new data, sort/subsort, then 'overwrite' your Excel range (excluding columns with formulas).

mihir_mir_jb

I kind of figured out the append issue - I deleted all the blank rows after row # 1619 (as mentioned earlier) and now the new data is getting appended from row # 1620. Though I had to remove the formulas from column B starting from row 1620.

Do you'll know how can I add back the formula using Alteryx?

Jean-Balteryx

You can't add Excel formulas using Alteryx. But maybe you can replicate them into Alteryx and append them as well.

HomesickSurfer

Hi @mihir_mir_jb

You can output to a named table range. I assume that the formulas in the excel table will extend to the additional rows.

Alternatively, you can recreate the formulas within Alteryx. I/we can help if you provide specific requirements.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703