workflow doc template table group by category

[i_yeh]

Hi Need help with doc expression for a workflow with the expected output (PDF): there's only one data table, appreciate your help thanks

Manufacturer A

Product 1	Chemical Name 1	Usage 1	CAS1	Certificate 1
Product 2	Chemical Name 2	Usage 2	CAS2	Certificate 2

---

Manufacturer B

Product 3

Chemical Name 3

Usage 3

CAS3

Certificate 3

[Steve]

Like this:

<<Start: ORDERBY(FILTER("Data Table", ([_RowNumber] = MIN(SELECT(Data Table[_RowNumber], ([Manufacturer] = [_THISROW-1].[Manufacturer]))))), [_RowNumber], FALSE)>>
<<[Manufacturer]>>
<<Start: ORDERBY(FILTER("Data Table", ([Manufacturer] = [_THISROW-1].[Manufacturer])), [_RowNumber], FALSE)>>
<<[Product]>>
<<[Chemical Name]>>
<<[Usage]>>
<<[CAS]>>
<<[Certificate]>>
<<End>>
<<End>>

[i_yeh]

thank you very much, it worked,

but I also have to group data by individual value in  "category" where column "category is enum list,  (each product can belong to multiple categories) , I need a pdf tables group by unique "category"
the above syntex does not work in this case.  appreciate your help thank you

[Steve]

Please explain more. I do not understand.

[i_yeh]

How to generate pdf product info group by individual value in "Application" column when it's a list

Applications: Thickener

Product	Process Platform
Metolose 90SH-100000	Direct Compression , Wet Granulation
Metolose 90SH-15000	HME , Coating
Metolose 90SH-4000	Direct Compression , Wet Granulation

Applications: Binders

Product	Process Platform
Metolose 90SH-100000	Direct Compression , Wet Granulation
Metolose 90SH-15000	HME , Coating
Metolose 90SH-4000	Direct Compression , Wet Granulation

Data Table: "Product Info"

Product	Applications	Process Platform
Metolose 90SH-100000	Thickener、Film forming、Binders	Direct Compression , Wet Granulation
Metolose 90SH-15000	Thickener	HME , Coating
Metolose 90SH-4000	Thickener、Binders	Direct Compression , Wet Granulation
Metolose 65SH-4000	Thickener、Binders	HME , Coating
Metolose 65SH-400	Thickener、Binders	Direct Compression , Wet Granulation
Metolose 65SH-50	Thickener	HME , Coating
Metolose 60SH-10000	Thickener	Direct Compression , Wet Granulation
Metolose 60SH-4000	Thickener	HME , Coating
Metolose 60SH-50	Thickener、Binders	Direct Compression , Wet Granulation
Metolose 90SH-100000SR	Sustained Release agent	HME , Coating
Metolose 90SH-15000SR	Sustained Release agent	Direct Compression , HME , Coating
Metolose 90SH-4000SR	Sustained Release agent	Wet Granulation
Metolose 90SH-100SR	Sustained Release agent	Direct Compression , HME , Coating
Aqoat AS - MF	Enteric Release、HME carrier	HME, Wet Granulation
Aqoat AS - MMP	Enteric Release、HME carrier	HME, Wet Granulation
L-HPC  LH 11	Binders、Disintegrant	Direct Compression , HME , Coating
L-HPC  LH 21	Binders、Disintegrant	Direct Compression , HME , Coating
L-HPC  LH 22	Binders、Disintegrant	Direct Compression , HME , Coating

[Steve]

The Product Info table you present above cannot be readily used to produce the report. To do what you want, you'll need a table that identifies each distinct Application. A simple table with only one column that lists all possible Application values would be sufficient.

[i_yeh]

Sorry, yes, there's a simple "Application" table as you mentioned above

how to write the doc template expression when it's  for workflow automation pdf?

thank you

[Steve · Accepted solution]

This?

<<Start: FILTER("Applications", ISNOTBLANK(FILTER("Product Info", IN([_THISROW-1].[Application], [Applications]))))>>
<<[Application]>>
<<Start: FILTER("Product Info", IN([_THISROW-1].[Application], [Applications]))>>
<<[Product]>>
<<End>>
<<End>>

[i_yeh]

YES!!!!! it works, thank you soooo very much. Appreciate your help.  You are amazing.