Forum Discussion
Fill down
Hi All,
I have a raw data that's being updated every month. What I need (don't know if it's possible or not) is to fill down the "Country" column, based on the above order.
The country's are always in this order:
Albania
Algeria
Argentina
etc.
When the new raw data is uploaded it doesn't include the country column, it only includes other columns (columns with values)
What I need is to fill down the new rows I've uploaded (new Raw data) with the Country names but in the same order.
At the moment if I use fill Down, it will select the last country name (Zimbabwe) and fill that name to all of the new rows, but I need it to remember the order of Country column and fill first row with Albania, second row with Algeria and so on.
Is this possible?
Hi, Anonymous
You can try the following methods. First you need to add an index column, starting from 1.
Create a new table and fill out the names of the countries you need to add in order.
Create a new custom column.
if [Column1] = "" then let a= List.Count(#"Added Index"[Column1]),b=List.Count( List.Select(#"Added Index"[Column1], each _ = "")),c=Number.Mod([Index]-(a-b)-1, 3) in #"Table (2)"{c}[Column1] else [Column1]Is this what you expect the output to be?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi, Anonymous
You can try the following methods. First you need to add an index column, starting from 1.
Create a new table and fill out the names of the countries you need to add in order.
Create a new custom column.
if [Column1] = "" then let a= List.Count(#"Added Index"[Column1]),b=List.Count( List.Select(#"Added Index"[Column1], each _ = "")),c=Number.Mod([Index]-(a-b)-1, 3) in #"Table (2)"{c}[Column1] else [Column1]Is this what you expect the output to be?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.