How to keep only first row of a column?

Question

What I have right now

MonthYearSalesStoreApril2021$$$0478April2021$$$0631April2021$$$0512April2021$$$0154

What I would like is

MonthYearSalesStoreApril2021$$$0478  $$$0631  $$$0512  $$$0154

ncrlelia · Answer

Hi @Aviator0807,

I would suggest to create an ID for each group of data so that it is easier to follow through.

Assuming that your group is defined by Month and Year,

* Use Multi-Row formula to create ID field*

* Use a formula tool to keep current Month and Year value if ID = 1.* I've set Year to String so that I can use Multi-Field formula. You can simply write 2 formula using the Formula tool for Month and Year separately, if your Year has to be Numeric 
*

Hope this helps.

Cheers,

Lelia

Workflow.yxmd

AngelosPachis · Answer

@mst3k suggestion should work if you create new fields with the multi-row formula tools, and then replace the old ones with a select tool

The issue that may arise with this approach though @Aviator0807  is that in case you have the same month but different years stacked on top of each other, that expressions will not address that change in year, as show below

Ideally this is why you should form a date field as proposed in my first post and then probably group by that field in the multi-row formula tool, before creating the logic.

example_v2.yxmd

Aviator0807 · Answer

@mst3k I tried that but wasnt getting the result I need.

This is what I was getting when I used that.

MonthYearSalesStoreApril2021$$$0487  $$$0235April2021$$$0951  $$$0520April2021$$$0874