If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
A Concatenate Formula Question
I am using Concatenate to build strings from a spreadhsheet. Mostly these are
based on prior records. My data was delivered sort of like this Parent | Name "" | Dockmaster Dockmaster | Level 1 Dockmaster | Level 2 Dockmaster | Level 3 None | Wharfloader Wharfloader | Level 1 etc So I created a new field FullName and used Concatenate to say if Parent"" then Concatenate PriorRecord#_FullName + CurrentRecord_Name e.g. Dockmaster Level 1 Obviously when ti gets to Wharfloader since parent is null it just use Wharfloader (and the next one is Wharfloader Level 1. The problem as you can see from this example is when there is more then one record in a row with the same parent. So I get Dockmaster Level 1 Dockmaster Level 1 Level 2 Since there can be any # of 'children' I am not sure what logic to use to force it to jump back to (in this case) Dockmaster. I'm hoping the answer is simple and just alluding me Any help appreciated. |
#2
|
|||
|
|||
A Concatenate Formula Question
Msnyc07 -
If you change the 'PriorRecord#_FullName' in your current concatenation to 'CurrentRecord_Parent', then you won't get the duplication. -- Daryl S "msnyc07" wrote: I am using Concatenate to build strings from a spreadhsheet. Mostly these are based on prior records. My data was delivered sort of like this Parent | Name "" | Dockmaster Dockmaster | Level 1 Dockmaster | Level 2 Dockmaster | Level 3 None | Wharfloader Wharfloader | Level 1 etc So I created a new field FullName and used Concatenate to say if Parent"" then Concatenate PriorRecord#_FullName + CurrentRecord_Name e.g. Dockmaster Level 1 Obviously when ti gets to Wharfloader since parent is null it just use Wharfloader (and the next one is Wharfloader Level 1. The problem as you can see from this example is when there is more then one record in a row with the same parent. So I get Dockmaster Level 1 Dockmaster Level 1 Level 2 Since there can be any # of 'children' I am not sure what logic to use to force it to jump back to (in this case) Dockmaster. I'm hoping the answer is simple and just alluding me Any help appreciated. |
Thread Tools | |
Display Modes | |
|
|