Hi,
how would I create this? I am stuck
In case of the multiple owners,
IIF(isNull([Row-1:SERIAL #]),1,[Row-1:OWNER-SEQUENCE-NUMBER]+1) as the expression?
use existing field of OWNER SEQUENCE NUMBER?
Solved! Go to Solution.
@Hi2023 Would you be able to provide the input data and expected output?
No, due to privacy concerns :/
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
@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
Yes, but due to privacy I cannot share data.
there is a couple things I need todo:
1.-In case of the multiple owners,
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?
-----------
Can I do this for up 4 owners?
@Hi2023 Yes, that is also possible but without seeing some sample data it is very difficult to understand the requirement
Could you show me an example using 4 owners?