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

selecting rows contain text from list and record list value.

My current code is:

let
    Source = #"CAL multiple action",
    #"Renamed Columns" = Table.RenameColumns(Source,{{"CALIBRATIONS_Omschrijving:", "Column1"}}),

    LookUp = #"ID_Unique",

    #"Filtered Rows" = 
        Table.SelectRows(
            #"Renamed Columns", 
            (r)=> List.AnyTrue(
                    List.Transform(
                        LookUp[Column1], 
                        each Text.Contains(r[Column1], _, Comparer.OrdinalIgnoreCase)
                        )
                )
        )
in
    #"Filtered Rows"

This will generate the table with rows containing items from the lookup list. Now I also like to now what value is found.

Any help is highly appreciated. (As you can see I'm not familiar with M-language but try to find my way around Smiley Wink ).

Thanks Christiaan

 

Table 1

ID-nummer:CountCALIBRATIONS.File NameCALIBRATIONS.ID-nummer:CALIBRATIONS_Omschrijving:CALIBRATIONS.Opname element:CALIBRATIONS.Model/type:CALIBRATIONS.Fysieke range:CALIBRATIONS.Interval:CALIBRATIONS.Testpunt(en)CALIBRATIONS.en tolerantie(s):CALIBRATIONS.Column1CALIBRATIONS.Column2CALIBRATIONS.Locatie:CALIBRATIONS.Fabrikant:CALIBRATIONS.Serie nr:CALIBRATIONS.Afleesnauwkeurigheid:CALIBRATIONS.Gebruikte range: CALIBRATIONS.Column3CALIBRATIONS.Procedure:CALIBRATIONS.Test standaard:

PM-954036PM-9540,25NewCSF.xlsPM-9540Temp. of -70 Freezer UK-7265Pt-100NA-200°C tot 400°C12 maanden≤ -80°C ± 3°C ≥ -50°C ± 3°C H-02Yokogawa 0.1°C-80 t/m -50°CWV00405Temperatuur standaard 
PM-954036PM-9540,24NewCSF.xlsPM-9540Temp. of Incubator KV-0180Pt-100NA-200°C tot 400°C12 maanden≤ 23°C ± 0.5°C ≥ 42°C ± 0.5°C H-02Yokogawa 0.1°C23 - 42°CWV00405Temperatuur standaard 
PM-954036PM-9540,39NewCSF.xlsPM-9540%RH probe of Incubator KV-0250NANA55 - 80 %RH12 maanden≤55  %RH ± 2 %RH ≥80 %RH ± 2 %RH H-02Yokogawa 0.1 %RH70 - 85 %RHAL00094%RH standaard 
PM-954036PM-9540,26NewCSF.xlsPM-9540Temp. of -70 Freezer UK-7270Pt-100NA-200°C tot 400°C12 maanden≤ -80°C ± 3°C ≥ -50°C ± 3°C H-02Yokogawa 0.1°C-80 t/m -50°CWV00405Temperatuur standaard 
PM-954036PM-9540,23NewCSF.xlsPM-9540Temp. of Refrigerator KK-1435Pt-100NA-200°C tot 400°C12 maanden≤ 2°C ± 0.5°C ≥ 16°C ± 0.5°C H-02Yokogawa03-2012-41210002-200-030.1°C2 - 16°CWV00405Temperatuur standaard 

 

Table 2

BM-0206
BM-0208
BM-0209
BM-0210
BM-0216
BM-0217
BM-0222
BM-0223
BM-0224
BM-0225
BM-0226

 

CALIBRATION.Omschrijving (4th column of table 1) contains codes from Table 2. I managed the selections of thw rows. But I like to know the values from Table 2 instead. 

3 REPLIES 3
Super User
Super User

Re: selecting rows contain text from list and record list value.

@acbakker Could you please post sample data and expected output which will help us to understand what you are trying to achieve.



Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !





acbakker Frequent Visitor
Frequent Visitor

Re: selecting rows contain text from list and record list value.

@PattemManohar

I have updated the post. Instead of heving the CALIBRATION>omschrijving selected with the codes in it I would like to know which once are used in that column.

 

Thanks for your support.

 

Community Support Team
Community Support Team

Re: selecting rows contain text from list and record list value.

hi, @acbakker

Your description of table 1 is a bit confusing, could you please rearrange it again and give us your  expected output?

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.