Alteryx Designer Desktop Discussions

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

Removing extra comma from delimited file

DharmaAcharya
6 - Meteoroid

Hi Everyone!

i have a specific requirement to produce a comma delimited file which has total row calculated at the top of the report. since rest of the columns are blank for the very first (total) row, i am getting only commas -- which is understandable HOWEVER my legacy backend application does not like those extra commas. Anyone come across this type of situation. Trying my luck with this awesome community before i make changes to the receiver.

DharmaAcharya_0-1670363596337.png

 

2 REPLIES 2
Qiu
20 - Arcturus
20 - Arcturus

@DharmaAcharya 
I am not sure your attached the correct one.

I have made some dummy data and hope it can give some hint.

Capture1B.PNGCapture1C.PNG

binuacs
20 - Arcturus

@DharmaAcharya One of the options I am thinking to use the Python tool to manipulate the final output file, something like the one below, I would defer it with @PhilipMannering , who one of the expertise in python tool

 

binuacs_0-1670368372801.png

 

Labels