Fix: Outputting to XLSB using Delete and append with "Take the file name From field"

[csmith11]

Writing to XLSB Files using Delete and Append does not behave properly.

Alteryx currently is having an issue with writing to an XLSB file using the Delete and append option with Take the file/table name From field.

Issue:

• Old data gets deleted, and new data is added but on the wrong row.
• New data is added after location where old data was originally.
• This output error for XLSB files only shows when using Take the file/table name From field. Static paths are fine.

Workaround:

Create a Batch macro to simulate the Take the file/table name From field function without actually using it.

Example of Issue:

Record ID	Original File	---->	Updated File
1	Old Data	---->
2	Old Data	---->
3	Old Data	---->
…	Old Data	---->
1200	Old Data	---->
1201		---->	New Data
1202		---->	New Data
1203		---->	New Data
…		---->	New Data