Setting a duplicate value in a column to null or zero

randall_white · July 2022

I have a dataflow where I'm joining projects to their respective tasks. Each project will have a large number of tasks associated with it and a planned/actual cost for the project. This results in many duplications of the cost and task data. Can I somehow set all duplications, after the first set, to 0 or null without removing the entire row? The entire row isn't a duplication but many of the columns contain a duplicated value. Its really messing up my graph by duplicating cost.

DOMO project and task dup issue.xlsx

RobSomers · July 2022

In the flow you can use a rank and window tile to do a row count for each project:

https://domohelp.domo.com/hc/en-us/articles/360044876094-New-Magic-ETL-Tiles-Aggregate

Then for each column you want the duplicates to be null, you can do a formula that says when the row number is not 1 then the value should be null.

randall_white · July 2022

That worked. Thank you!

Setting a duplicate value in a column to null or zero

Answers

Categories