Group and Concatenate Reporting Fields

Hi Everyone --

I am working on a project and came across an obstacle.

Here is what I did. I was able to successfully -- using the reporting tools --create links to one of our internal systems so as a person is reviewing the spreadsheet, then can click a link and be taken right to the document. See image below:

I need to join this data back to a master list of data. So the issues is that each GTN is unique in the master list and cannot be repeated. It would be perfectly acceptable to group by GTN, Concatenate by Transaction Unique ID and Concatenate by TTR link.

Problem is that it appears the TTR link column cannot be concatenated.

Is there a way around this?

Thanks,

Seth

Reporting

Preparation

Accepted answers

All comments

drew9

Hi @smoskowitz ,

Can you please attach a cleansed version of your workflow?

smoskowitz

@drew9 --

Thank you for the response.

What I would like to see is

GTN	Transaction Unique ID	Value Field (clickable links)
AS982C	2021-Q2-11806,2021-Q2-11806,2021-Q2-11852	2021-Q2-11806,2021-Q2-11806,2021-Q2-11852

Each Transaction ID is clickable and each would take me to a different part of our internal system.

Thanks,

Seth

Concatanate Report Field.yxmd

drew9

so you can't concatenate TTR as it is a reporting object. But can you use the same logic you're using in the reporting tools to create you're link as a normal string? I'd like to see the portion of your workflow where you actually create the link as opposed to having it in a text input.

smoskowitz

@drew9 -

I can certainly take the link and concatenate it -- you're right as it certainly isn't the issue. I was hoping to make it clickable and concatenate it.

Apologies for the confusion.

Seth

PhilipL

@smoskowitz Try converting all to text objects, then combining. See attached.

Check it out.

Phil

Build Text Objects.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703