Copying a row based on a certain Criteria

Attached file shows the same input and the expected output. Criteria is if column 6 = 'And' then copy the entire row with all the same column values except for column 7,8 and New column. The copied row will have the column 8 under column 7 and new column value = 2 which signifies that it is the second person on the account.

Thanks for your help in advance!

Cheers!

Developer Tools

Common Use Cases

Data Investigation

Accepted answers

binu_acs

@Idyllic_Data_Geek One way of dong this

Copy_Row_10_06.yxmd

ddiesel

Hi @Idyllic_Data_Geek!

If the column name is "Serial #" then the formula would look like this:

IIF(isNull([Row-1:Serial #]),1,[Row-1:New Column]+1)

Pay attention to the data type for "Serial #" and "New Column". They both must be numeric for this formula to work.

As @gabrielvilella mentioned, if you upload some dummy data and the desired output, we can help you troubleshoot it.

Thanks,
Deb

All comments

Qiu

@Idyllic_Data_Geek
I think we can do it by a Transpose tool and a Tile tool as below.

We will bring the column of names vertically then use a Tile tool to give ID per group.

0610-Idyllic_Data_Geek.yxmd

binu_acs

@Idyllic_Data_Geek One way of dong this

Copy_Row_10_06.yxmd

Idyllic_Data_Geek

Thank you. Can you please explain what is this calculation doing? IIF(isNull([Row-1:1]),1,[Row-1:New Column]+1)

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335