Table Transformer - concatenate data from multiple rows based on criteria

[Joel Tabares]

Hi,

SQL functions in Table Transformer is limited that i'm having trouble concatenating/merging data from multiple rows.

Table

Project  | Remarks

P1   |  The quick brown

P1   |  Fox jumps

P2   |  Over the

P2   |  Lazy dog

I need it to produce the output below:

Project | Remarks

P1   | The quick brown Fox jumps

P2   | Over the Lazy dog

[Jakub Pierzchała · Accepted solution]

Yes, the base URLs are configured correctly. I have noticed however that the Application Link points to the OnDemand JIRA instance but when I try to add the hosted JIRA as well it throws an error about the same Server ID. Your colleagues at support are currently helping me to deal with this.

[Harry Chan]

Check the exported xml and see what the links look like. From memory I think they are hardcoded URLs. Your best bet might be a mass search and replace on the xml after the export and before the import.

[Jakub Pierzchała]

Hmm, this is an interesting approach. I will give it a try

[Dave]

Hi Jakub,

Have you updated your base URL? You can check out the Configuring JIRA Options page for details on changing that. If this isn't the case, and it's just the Application Links, these may have to be updated via the instructions at Integrating JIRA and Confluence. Let us know if you run into any trouble!

Thanks,

-dave