How to generate sequences from columns and convert into a list

Question

Hi Everyone,

I need to generate codes for the data I have in four columns and have to create a list by generating codes.

Input

C1C2C3C4TreePlantBushSapling

Output Required

CCodeTree101Plant1011Bush10111Sapling101111

danilang · Answer

Hi @Disha03

To modify @Qiu's workflow to work with multiple input rows,

1.  Add a RecordID tool before the transpose and call this new field RowID

2. Change the original RecordID tool to a multi-row

a. creating a field called tool RecordID

b. grouped by RowID

c. use [Row-1:RecordID]+1 as the formula to generate sequential ids within each RowID

2. In the original Multirow tool,

a. Group by RowId

b. Modify the to use the RowID in the initial part of the code.

Dan

Disha03 · Answer

This is only working when we have one row.

In case of 1,000s of categories where we need codes to change automatically by identifying next category this workflow will not work.

Input

C1C2C3C4xx1x2x3y

y1y2y3zz1z2z3

Output Expected:

CCodex101x11011x210111x3101111y102y11021y210211y3102111z103

Qiu · Answer

@Disha03 
I am not sure your code naming convention here. so just go with the straightforward way.

0317-Disha03.yxmd