Hi all, I need to copy the above values in the same order to the null values I have in the column. FamilyProvinceSolanoSan JosePerezHerediaBonillaCartagoTrejos PuntarenasBarboza Lopez Gomez Torres FamilyProvinceSolanoSan JosePerezHerediaBonillaCartagoTrejos PuntarenasBarboza San JoseLopez HerediaGomez CartagoTorres Puntarenas I really appreciate your help on this.

Copy values of column to null values

Hi all,

I need to copy the above values in the same order to the null values I have in the column.

Family	Province
Solano	San Jose
Perez	Heredia
Bonilla	Cartago
Trejos	Puntarenas
Barboza
Lopez
Gomez
Torres

Family	Province
Solano	San Jose
Perez	Heredia
Bonilla	Cartago
Trejos	Puntarenas
Barboza	San Jose
Lopez	Heredia
Gomez	Cartago
Torres	Puntarenas

I really appreciate your help on this.

Datasets

Accepted answers

Qiu

@bersocha
If I understand you correctly.
First I assgined a Record ID so later on we can have the correct the sequence as orginal.

Then we seperate the null and non-null value asssign sequence ID for each stream then join them sequencely.

0601-bersocha.yxmd

All comments

ddiesel

Hi @bersocha!

I think we might need more details to help with the best solution. Can you provide more information about the structure of your incoming data?

I have a hunch that the Multi Row Formula tool might do the trick. Or we might need to use something like a Tile tool to add a RecordID and Sequence with a Join tool to repeat the missing values.

binu_acs

@bersocha one way of doing this.

copyValues_01_06.yxmd

bersocha

Yes, Let’s say that I have 7 columns, 6 with a thousand rows and the other column with only 500 rows. So the other 500 rows are null, my idea is to copy again the 500 rows in the other 500 null rows that I have. Such as the table I uploaded where I’m repeating from San Jose to Puntarenas in the null cells.

Qiu

@bersocha
If I understand you correctly.
First I assgined a Record ID so later on we can have the correct the sequence as orginal.

Then we seperate the null and non-null value asssign sequence ID for each stream then join them sequencely.

0601-bersocha.yxmd

grazitti_sapna

Hi @bersocha, try this if it works for you.

Thanks!

bersocha_workflow.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703