Forum Discussion
pbi1908
Helper III
Helper IIICreate a flag if a table contains a string before expand.
Hi all, I am connected to a folter with PDFs, i receive these PDFs once a month and the structure of the PDF is not standard, sometimes the customer send me a PDF with 10 pages, sometimes with 2...
Hi pbi1908
You can try the following code
Table.AddColumn(#"Filtered Rows", "Custom", each if List.Contains([Data][Column1],"Container") then 1 else 0)
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.