Deleting First 10 Column but without deleting start and end rows

[skotian1289]

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

[vizAlter]

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

[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 : )

[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

[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

[atcodedog05]

Hi @skotian1289 ,

Please find the workflow giving expected output.

Hope this helps : ) Let me know if you want it to be more calibrated.

[grazitti_sapna · Accepted solution]

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

Thanks.

[vizAlter · Accepted solution]

@skotian1289 — Try this one...

[skotian1289]

Hi,

Thank u so much for your solution, I have a quick question.

My file name in the first row will change everyday as and when report is generated, so will the formula incorporate that when we run the tool everyday?

Thanks

[atcodedog05 · Accepted solution]

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.