Concatenate content in rows only from specific columns

Hi, I am trying to put all the different rows that are part of one single address in just one line, without changing the other rows: store, id and date. Note that one store might have many ID's and dates, but there has to be only one row for address. Find image attached.

Thanks in advance.

Screenshot (12).png

Workflow

Help

Expression

Accepted answers

alexnajm

I assume the address should repeat based on the Store column? Here's a workflow that should work for your purposes:

Concatenate content in rows only from specific columns.yxmd

Luke_C

Hi @AnaLG

What do these addresses relate to? The store? Assuming yes then you could do something like this:

Fill down blank stores
Group by store and concatenate address
Join address back to data

Concat.yxmd

alexnajm

You can create a grouping field of sorts using the Multi-Row Formula tool - in this case, looks like you could use it to create a grouping for every 4 rows (i.e. first 4 rows is group 1, next 4 is group 2, etc.). But that's dependent on the logic of the data and finding something that's repeatable!

All comments

alexnajm

I assume the address should repeat based on the Store column? Here's a workflow that should work for your purposes:

Concatenate content in rows only from specific columns.yxmd

Luke_C

Hi @AnaLG

What do these addresses relate to? The store? Assuming yes then you could do something like this:

Fill down blank stores
Group by store and concatenate address
Join address back to data

Concat.yxmd

AnaLG

Thanks so much for your help Luke_C and alexnajm.

That work, how would I do the exact same thing if there was no 'store' column to group by?

alexnajm

@AnaLG You need at least a column to group on - otherwise how would we know what rows concatenate with one another?

AnaLG

I have another table where I have nothing to group by, so I don't really know how to concatenate the address rows, since there if no reference number or nothing to group by. So, in this case each address is associated to a few modules, and I want to concatenate both columns 'address' and 'modules'. See table attached. Would you know how can I do that? Thanks so much. Screenshot (14).png

alexnajm

AnaLG

Great, I will try to do that. Thank you!

alexnajm

Fantastic. If it truly is split by an equal amount of records, you could also look at the Equal Records option of the Tile tool!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703