Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

insert specific rows from a table into a second table with condition

Hello,   I have 2 excel file : one with the detail of every piece, and one with the detail of every machine/operator. and   I want to copy on first excel (piece) specific rows of the se...
Need Help
  • KT_Bsmart2gethe's avatar
    KT_Bsmart2gethe
    4 years ago

    Hi Anonymous ,

     

    The ideal way to have your challenge resolve in a timely and accurate manner is by providing data in table format with all sensitive information removed.

     

    Please see below for proposed solution.

     

    Table1: The detail of every piece

    Table2: The detail of every machine/operator

     

    Below is a direct query and extract data from Table1 to Table2:

     

    1. Add a custom step and add formula below (i.e. the direct query method):

    if [#"ok/nok"] = "ok" then Table.SelectRows(Table2,(x)=> ([piece] >= x[begin piece] and [piece] <= x[end piece])) else null

     

     

     

    2. Expand the column:

     

     

    Result:

     

    Regards

    KT

     

KT_Bsmart2gethe's avatar
KT_Bsmart2gethe
Impactful Individual
4 years ago

Hi Anonymous ,

 

The ideal way to have your challenge resolve in a timely and accurate manner is by providing data in table format with all sensitive information removed.

 

Please see below for proposed solution.

 

Table1: The detail of every piece

Table2: The detail of every machine/operator

 

Below is a direct query and extract data from Table1 to Table2:

 

1. Add a custom step and add formula below (i.e. the direct query method):

if [#"ok/nok"] = "ok" then Table.SelectRows(Table2,(x)=> ([piece] >= x[begin piece] and [piece] <= x[end piece])) else null

 

 

 

2. Expand the column:

 

 

Result:

 

Regards

KT