Delete specific Data Cells

[Ebarbou1]

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

[Amol_Telore · Accepted solution]

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