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

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 ANTWORTEN 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.

Beschriftungen