Delete specific Data Cells

Hello.

I am trying to delete specific cells in my work file.

In the picture I have attached, I would like to only delete rows 159 and beyond in only columns Budget and Function.

Is there a formula or way I can just delete the data in these cells, but leave everything else?

Thank You

remove data.JPG

Datasets

Developer Tools

Custom Tools

Common Use Cases

Accepted answers

Amol_Telore

Hey @Ebarbou1

One way to do this is add a Record_ID tool which will add row number in the data and after record ID tool add formula tool.

In the formula tool, you will have to write a IIF statement. If row number is greater than 158 then show Null else show original data.

Ex. IIF( [Record_ID] > 158, NULL(), [Budget] )

You can also use multi field tool for simplicity. Hope this is what you are looking for.

All comments

Amol_Telore

Hey @Ebarbou1

One way to do this is add a Record_ID tool which will add row number in the data and after record ID tool add formula tool.

In the formula tool, you will have to write a IIF statement. If row number is greater than 158 then show Null else show original data.

Ex. IIF( [Record_ID] > 158, NULL(), [Budget] )

You can also use multi field tool for simplicity. Hope this is what you are looking for.

DanielG

@Ebarbou1 Assign a Record ID to each row and then a formula for each of the columns you want to cleanse that says if RecordID>159 then [ColumnName] = 0, or null or whatever you want it to be.

That is assuming that it will always be at Row 159 every single time. If it needs to be more dynamic than the answer will be different.

DanielG

@Amol_Telore Nice. You beat me to it.

Amol_Telore

@DanielG I just got lucky this time. 😀

Ebarbou1

Hi,

I apologize I am still fairly new to Alteryx. Doesn't the record tool add a new column, not a row?

I don't want to add new column, I just need the data after row 158 from columns functions and budget to be removed.

DanielG

@Ebarbou1 - it adds a column, but you could just remove it in the next step (select tool most likely). Otherwise there really is not way to know when to start/stop the removal of data.

Ebarbou1

I understand now, thank you

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703