Create new column that repeat values

3 posts / 0 new
Last post
Fernando Na
Offline
Joined: 08/08/2022 - 09:28
Create new column that repeat values

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.

 

Images: 
Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

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.

Fernando Na
Offline
Joined: 08/08/2022 - 09:28

Thanks Brian, passport utility worked just fine!