Assistance with Practice exercice 4 ADAPT

[saidworks]

I tried solving the fourth exercise after strugglng lot with transpose and cross tab, I got an idea of using record ID thanks to the discussuons forum here. But I seems not getting the right answer as I have 5 more records then the solution!

Can you help me  please, what I am missing here?

[bpatel]

hi @saidworks ,

Do you have an example of what the end result is supposed to look like? the file is missing from the attached workflow.

[saidworks]

sorry I forget to attach it, here it is. Thank you

[bpatel · Accepted solution]

@saidworks ,

you are on the right track. instead of using a formula to concatenate all product categories, try using the summarize to do that for you. i attached the workflow as well.

hope this helps!

[Airedelapaz]

I'm stuck!!!  Can anyone help????