cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rfaure Frequent Visitor
Frequent Visitor

Re: [Power Query - M] Text.Contains

You can find my data on xlsx in a zip with this link :

 

https://takeafile.com/?f=tuyegijesu

 

Thanks you

 

Rfranca Member
Member

Re: [Power Query - M] Text.Contains

hi, @rfaure 

 

Hi
 
Check if this is what you need?
One only question that remained is when an [Complémentaire] has two [Réseau] like you want to do with it.

 

Clipboard011.gifClipboard012.gif

 

 

Please try and test using it. And please mark the right reply as answer if your issue has been resolved, otherwise, please feel free to ask if you have any other issue.

Best Regards,
Rfranca

rfaure Frequent Visitor
Frequent Visitor

Re: [Power Query - M] Text.Contains

I'm sorry, I did not really understand the manipulation. My adaptation was completely erratic. But your solution works properly. thank you very much

Rfranca Member
Member

Re: [Power Query - M] Text.Contains

hi, @rfaure

 

 

To help you apply to your database, I'm sending the sample file.

 

https://takeafile.com/?f=gisafojiju

 

Please feel free to ask if you have any other issue.

Best Regards,
Rfranca

rfaure Frequent Visitor
Frequent Visitor

Re: [Power Query - M] Text.Contains

I now have a new problem to adapt the solution to the actual database. he returns the following error :

 

Capture.PNG

 

I think I know where this error comes from. Currently my database is created thanks to a multitude of CSV file (monthly extraction). This file is compiled together with a query function that I adapted.

 

Example : 

 

I have the following directory consists of several csv file that I have to compile into one to form a single table.

 

Capture.PNG

 

Then using a query function I compile all the files.

 

Capture.PNG

 

RecupPatient :

 

let
    RecuperationPatient = (MonFichier) =>
let
    Source = Csv.Document(File.Contents(MonFichier),[Delimiter=";", Columns=35, Encoding=1252, QuoteStyle=QuoteStyle.None]),
    #"Premières lignes supprimées" = Table.Skip(Source,2),
    #"En-têtes promus" = Table.PromoteHeaders(#"Premières lignes supprimées", [PromoteAllScalars=true])
in
    #"En-têtes promus"
in
    RecuperationPatient

 

 

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 6 members 2,560 guests
Please welcome our newest community members: