Highlighted

Merge multiple rows into one row

Explorer ,
Jul 10, 2015

Copy link to clipboard

Copied

We are using CF10. I am writing a query that feeds into an adobe report builder report. Several tables are involved.

I need the name, address, and the checklist items on one row. There can be up to 3 checklist items per name, one name, one address.

The data looks something like this

Joe Student123 MainHI
Joe Student123 MainPD
Sam Student124 MainJP
Anne Student125 MainHI
Anne Student125 MainJP

The output should look like this:

Joe Student     123 Main     HI     PD

Sam Student   123 Main    JP

Anne Student   123 Main    HI     JP

TOPICS
Database access

Views

278

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Merge multiple rows into one row

Explorer ,
Jul 10, 2015

Copy link to clipboard

Copied

We are using CF10. I am writing a query that feeds into an adobe report builder report. Several tables are involved.

I need the name, address, and the checklist items on one row. There can be up to 3 checklist items per name, one name, one address.

The data looks something like this

Joe Student123 MainHI
Joe Student123 MainPD
Sam Student124 MainJP
Anne Student125 MainHI
Anne Student125 MainJP

The output should look like this:

Joe Student     123 Main     HI     PD

Sam Student   123 Main    JP

Anne Student   123 Main    HI     JP

TOPICS
Database access

Views

279

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Jul 10, 2015 0

Have something to add?

Join the conversation