Deleting First 10 Column but without deleting start and end rows

Hello All, am sure this will be a quite simple solution however I need assistance as I am not able to achieve below results.

I want to delete the first 10 columns of my data however the start and end row need to remain intact as it contains FIle details . I am able to delete the columns however when I do that the first and end rows are also affected. I am attaching sample raw files and expected results files if it helps Thanks

Sample Data Plus expected Output.csv

Data Investigation

Accepted answers

grazitti_sapna

Hi @skotian1289 , is this what you are trying to achieve?

Thanks.

delete first 10 columns-GS.yxmd

vizAlter

@skotian1289 — Try this one...

Get Columns_v2.yxmd

atcodedog05

Hi @skotian1289 ,

The workflow will manage to work provided the number of columns will remain same.

If this solves your task please mark my post as solution.

vizAlter

@skotian1289 — Thank you for marking the solution accepted!

Just for being curious, I have tried a little more something... look at this solution (Get Columns_v4.yxmd) as well.

Now, you can export the exact format through Output tool (if want or learn):

In first workflow there is a delimiter comma as part of csv file which is creating multiple columns.

Second workflow its considering data as txt file with no delimiter hence only one column.

Where in both workflow data format is different hence cannot be integrated in a single workflow easily.

There might be a possibility but its posses a risk of improper output.

Hope this helps 🙂

All comments

vizAlter

Hi @skotian1289 — Try this solution... or try to modify the expression, shown below:

Get Columns.yxmd

atcodedog05

Hi @skotian1289 ,

As per what you are saying you want to remove first 10 columns.

It can be done using Dynamic Select Tool

Since you have saved it as a .csv it has dropped out Sample data or expected output sheet.

If you provide those will be able to help you better : )

Delete Column.yxmd

skotian1289

Hi VizAlter,

Thanks for the response, however with your solution the column 1 is still part of output. I want to delete the first 10 columns but the first and last row should remain intact. See attached my expected output, if it helps.

Thanks

expected Output.csv

skotian1289

Hi,

My bad here is attached my expected output.

Yes deleting first 10 columns is achievable but I have my file name in first row and then End command in the last row of data values, and I don't want those to be deleted. That is where the challenge is and I am stuck.

Thanks

expected Output.csv

grazitti_sapna

Hi @skotian1289 , is this what you are trying to achieve?

Thanks.

delete first 10 columns-GS.yxmd

skotian1289

@grazitti_sapna

@atcodedog05

I am stuck with a small glitch especially when both my input and output is a csv format with delimiter as , . Is this an alteryx glitch because if manually do it these excess delimiters does not appear.

My Output looks sumthing like below in notepad++

File Name ver 10 ABC,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

"Column 1","Column 11","Column 12","Column 13","Column 14","Column 15"

"1","","","","","22","","","","","44","","","","","66","","","","77","","","","","88","","",""

END-File name,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

My only problem is the excess commas in first and last line rest double quotes and commas in other lines are perfect and matches our requirement. I tried to replace the commas in first and last line but they wont go and if I remove Delimiters in Output column all the delimiters in my output would disappear . Is there a way we can remove Delimiters only from specific places.

The issue is when we union the two CSV files there are blank spaces created in front of "File Name ver 10 ABC" and "END-File name" which is creating multiple delimiters. Not sure if its a alteryx glitch.

Thanks

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703