Fill as series down if not exists - multi-row tool

I'm having a hard time copying down a LINK_ID for rows of data if it doesn't exist. I've triple checked the formula and I'm sure it's something silly

It doesn't seem to evaluate the [ROW-1:LINK_ID] to be null.

See the formula for the commented out code that shows you what I've attempted.

FILLsERIESiFNOT EXISTS.yxmd

Common Use Cases

Data Investigation

Accepted answers

grazitti_sapna

Hi @gurth , I have also prepared a solution for the same. Please refer to the screenshot and workflow for the desired output.Try this if it works!

FILLsERIESiFNOT EXISTS_GS.yxmd

All comments

fmvizcaino

Hi @gurth ,

Here is an example showing how to accomplish what you are looking for.

1. Remove the string [null] and replace by a true null value (maybe this was generated when you copy paste the dataset

2. Order in a way that Link_id and this_link_id will be ordered from value to null

3. Multi-row to replace IDs - Since you are grouping by GUI, there is no need of checking [name]=[row-1 name] since it is all the same. But if you need to check that, you can group by name also and it will work the same as [name]=[row-1 name]

4. Sorting back to normal order.

Best,

Fernando Vizcaino

FILLsERIESiFNOT EXISTS.yxmd

grazitti_sapna

Hi @gurth , I have also prepared a solution for the same. Please refer to the screenshot and workflow for the desired output.Try this if it works!

FILLsERIESiFNOT EXISTS_GS.yxmd

fmvizcaino

Great solution @grazitti_sapna

gurth

I still can't get it to work. I mistakenly left the GUI column in last time sorry!

I want to assign a previously assigned LINK_ID for that person (by checking [Row-1:*] name details, and if thye're the same person, copy down [Row-1:LINK_ID*] . If the person hasn't has a LINK_ID previously issued, copy [THIS_LINK_ID] on the active row to [LINK_ID]. See attahced

fillSeries.yxmd

gurth

I hadn't seen this post until after I posted my latest update. U'll review what you've provided and get back to you. Thanks to the both of you for your assistance.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703