Challenge #36: Data Cleansing Extract Authors

[pawanmalik]

My solution for this challenge.

[DM7]

Solution attached

[kevin025]

Here is my solution

Some formula explanation is below

Spoiler

IF [PMID_Num] = 0 &&
isEmpty([Row-1:PMID_Num])

THEN 1

ELSEIF [PMID_Num] = 0

THEN [Row-1:PMID_Group]+1

ELSE [Row-1:PMID_Group]

ENDIF

Since we know that each new group starts with 0, we start our IF statement by checking if the New Group starts with 0 AND if the row before it is 0 which is basically initialize the starting number to be 1 by conditioning THEN

We check again with IF statement for the NEXT new group that starts with 0
Then we increment each row before the PMID_Group by 1, so now it is Group 2 and so on.

I also included comments in my solution. Have fun exploring!

[treepruner]

I am getting faster at solving these. Might be getting time to take the core test!

[priya-18]

tricky challenge, got used to Multi-row formula 

[Santzu]

Can someone help with how I can change multiple header names at once ?

Eg - FAU1, FAU2 to Author1, Author2 and so on..

Thank you!

[Santzu]

Think I resolved it. You can use the ReplceChar expression in the formula tool.

[PrynsTag]

Turned the solution as a guide to finish this challenge

Spoiler

[JethroChen]

Spoiler

[wwatson]

my solution