Forum Discussion
insert specific rows from a table into a second table with condition
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
Hi,
1. On table 2 (Operator) Add a custom column to see all the pieces between the "begin piece" and the "end piece"
{Number.From([begin piece])..Number.From([end piece])}
2. expand list
3. Created a duplicate table 1 (ok/nok)
4. Filtered to see only "ok"
5. Merge Table 2 (custom column) onto Table 1 (Piece)
6. Expand table
7. Merge Duplicated Table1 onto Original Table1
8. Expand table to include only the columns you want
End Result: