Concatenate row by ID_SESSION with order PAGE_VIEW_ID respected

[Anonymous]

Hello,

i try to achieve this result from this

From this:

ID_SESSION ID SESSION_DEBUT POPULATION PAGE_VIEW_ID SOURCE TARGET
100069-1-2018-11-06 101 1541507397 client 1 1-home 2-products
100069-1-2018-11-06 101 1541507397 client 2 2-products 3-services
100069-1-2018-11-06 101 1541507397 client 10 10-toto 11-faq

this:

ID_SESSION ID SESSION_DEBUT POPULATION PAGE_VIEW_ID SOURCE TARGET JOURNEY
100069-1-2018-11-06 101 1541507397 client 1 1-home 2-products 1- home > 2-products > 3-services > … > 10-toto > 11-faq
100069-1-2018-11-06 101 1541507397 client 2 2-products 3-services 1- home > 2-products > 3-services > … > 10-toto > 11-faq
100069-1-2018-11-06 101 1541507397 client 10 10-toto 11-faq 1- home > 2-products > 3-services > … > 10-toto > 11-faq

I tried this solution (i tried many solutions from different topics) because it was the one that achieved the best:

Journey = CONCATENATEX(FILTER(ALL('Table1');[ID_SESSION]=EARLIER('Table1'[ID_SESSION]));[SOURCE];" > ")

On this, even if i have sorted by PAGE_VIEW_ID to have 1,2,...,10,11,etc., he does return 1 > 10 > 11 > ... > 2 like the sort never happened (i have sorted in power query by ID_SESSION and PAGE_VIEW_ID) even if in preview it is well sorted 1, 2,3,4 etc.

Thanks by advance,

Morgan

[v-frfei-msft]

Hi @Anonymous ,

Could you please share your sample data and excepted result to me if you don't have any Confidential Information.Please upload your files to One Drive and share the link here.

Regards,

Frank

[Anonymous · Accepted solution]

Hi,

sorry for being late but i resolved my problem.

I used a Reference Query to keep the sort perfectly and then used text.combine in a grouped rows query and then i created a new column using RELATED function to works perfectly 🙂

Thanks again !