Darshan Hiranandani : can I fill lower rows with data from upper rows based on conditions?

[Inactive User]

Hi Team,

I am Darshan Hiranandani, I have raw data where ColC contains both values and non values, with the non-values represented as 0. We want to fill the non-values in ColC with data based on specific conditions. Specifically, we need to fill in the 0 values in ColC with information from rows where ColC is non zero, grouped by ColA and ColB.

Regards

Darshan Hiranandani

[griffinwelsh]

@Inactive User you can do this with a mutli-row formula tool.

1.sort the data by you grouping and COIC in descending order

2.Use the below multi-row formula to update COIC. Make sure to select your group by fields.

if [COIC] = 0 then [Row-1:COIC] else [COIC] endif

[alexnajm]

If this is meant for the Cloud forum, it depends on which mode you have - if you are using the Cloud Native for example, multi row formula tool is not available :/

https://help.alteryx.com/aac/en/designer-experience/workflows/cloud-native-mode-versus-standard-mode...