Create new column that repeat values

Fernando Na

Forums

Im trying to create a new column   ("FILE ID")    that contains a value from another one. I want this value to be repeated by "Codigo". Everytime "Codigo" changes, The "FILE ID" column must have the new FILE ID. This value can be repeated, and "Codigo" can be repeated too.

 

Brian Element Tue, 08/09/2022 - 08:39

Hi Fernando, could you sort the file by Codigo and Values so that the Value is in the first row?  After doing that you can use the fill-down script that you can find on this site or part of the Utility SmartAnalyzer package that you can get from Passport.  This would then populate all the blank Values with the first value.