Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Overwrite selected columns and retain content in other columns

MadhuraBuchake
7 - Meteor

Hello All,

 

I have 13 columns and I need to overwrite only the first 10 columns. The data from columns K-M should remain the same. I tried doing the following things but nothing worked:

1. While saving the sheet I specified the column range. (A-J)

2. In the output tool I specified " data.xlsx|||Overwrite$A:J " by this way, and also used the 'Overwrite Sheet/ Range' option.

 

Please let me know what can be done.

Please find attached the screenshots.

 

Thank you!!

 

 

 

 

20 REPLIES 20
alexnajm
17 - Castor
17 - Castor

Did your original TestOutput1.xlsx have 13 columns before execution? If so, then I am not sure I can help any further as the expected behavior is working on my end. I would check the release notes for your version of Alteryx to see if there is some sort of known bug, and consider upgrading to a more recent version of Alteryx if that's the case.

Labels