Multi Row Formula Tool - Multiple Columns

Hello,

I am hoping someone has a solution for this. I have pricing information over time for multiple items. Is there a way to replace future data (nulls) with the last value? I would like a solution that if I add new columns the formula would apply to them as well.

Datasets

Accepted answers

Qiu

@cjmason105
There is a typical use case of Cross Tab and Transpose if I understand your intention correctly.

We use Transpose to bring multiple columns in to one then process, at the last use Cross Tab to restore the data structure.

0407-cjmason105.yxmd

All comments

Luke_C

Hi @cjmason105

Maybe @patrick_digan 's macro can help: https://community.alteryx.com/t5/Engine-Works/Step-Through-the-Multi-Verse/ba-p/903462

Qiu

@cjmason105
There is a typical use case of Cross Tab and Transpose if I understand your intention correctly.

We use Transpose to bring multiple columns in to one then process, at the last use Cross Tab to restore the data structure.

0407-cjmason105.yxmd

cjmason105

Sorry for the delayed response but this is exactly what I needed. Thank you so much!

Qiu

@cjmason105
Thank you for the feedback and I am happy it is helpful.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703