Multi- Row Formula

[Hi2023]

Hi,

how would I create this? I am stuck

In case of the multiple owners,

• Owner-Sequence-Number will be 1 for Primary owner
• Owner-Sequence-Number will be 2 for Secondary owner/s

IIF(isNull([Row-1:SERIAL #]),1,[Row-1:OWNER-SEQUENCE-NUMBER]+1) as the expression?

use existing field of OWNER SEQUENCE NUMBER?

[binuacs]

@Hi2023 Would you be able to provide the input data and expected output?

[Hi2023]

No, due to privacy concerns :/

[binuacs · Accepted solution]

@Hi2023 This can be achieved using Tile tool as well as Multi-Row tool

[Hi2023]

So if I use a tranpose tool infront of the multi row, what do I Select on that tool? I get confused on this part

the columns that will remain the same are:

Stae, Account, serial#

Are those the ones I Select? 

thanks

[binuacs]

@Hi2023 yes the common columns usually we select in the transpose tool as key columns. Also without seeing the dummy data it is difficult to say what you are looking for. If possible provide some dummy data and expected output records, if not try with the above solution

[Hi2023]

Yes, but due to privacy I cannot share data.

there is a couple things I need todo:

1.-In case of the multiple owners,

• Owner-Sequence-Number will be 1 for Primary owner
• Owner-Sequence-Number will be 2 for Secondary owner/s

2. If a serial # contains multiple owners then create a second row with the same sequence # for the secondary owner.

heres what I am doing in workflow:

so filtered for Multi owners

then transpose w common columns selected, then multi row tool (not sure if I need to select more columns)

then formula for last serial# part but once I get here the columns I need arent there so I need to select them on multi row tool? 

-----------

[Hi2023]

Can I do this for up 4 owners?

[binuacs]

@Hi2023 Yes, that is also possible but without seeing some sample data it is very difficult to understand the requirement

[Hi2023]

Could you show me an example using 4 owners?