Exemple #1
0
             quote_character=None))

# Delete rows 1,2
w.add(
    dw.Filter(column=[],
              table=0,
              status="active",
              drop=False,
              row=dw.Row(column=[],
                         table=0,
                         status="active",
                         drop=False,
                         conditions=[
                             dw.RowIndex(column=[],
                                         table=0,
                                         status="active",
                                         drop=False,
                                         indices=[0, 1])
                         ])))

# Delete empty rows
w.add(
    dw.Filter(column=[],
              table=0,
              status="active",
              drop=False,
              row=dw.Row(column=[],
                         table=0,
                         status="active",
                         drop=False,
                         conditions=[
             which=1,
             max=1,
             positions=None))

# Delete row 94
w.add(dw.Filter(column=[],
                table=0,
                status="active",
                drop=False,
                row=dw.Row(column=[],
             table=0,
             status="active",
             drop=False,
             conditions=[dw.RowIndex(column=[],
                  table=0,
                  status="active",
                  drop=False,
                  indices=[93])])))

# Delete row 94
w.add(dw.Filter(column=[],
                table=0,
                status="active",
                drop=False,
                row=dw.Row(column=[],
             table=0,
             status="active",
             drop=False,
             conditions=[dw.RowIndex(column=[],
                  table=0,
                  status="active",
            table=0,
            status="active",
            drop=False,
            result="column",
            update=False,
            insert_position="right",
            row=dw.Row(column=[],
                       table=0,
                       status="active",
                       drop=False,
                       conditions=[
                           dw.RowIndex(column=[],
                                       table=0,
                                       status="active",
                                       drop=False,
                                       indices=[
                                           0, 4, 8, 12, 16, 20, 24, 28, 32, 36,
                                           40, 44, 48, 52, 56, 60, 64, 68, 72,
                                           76, 80, 84, 88, 92, 96
                                       ])
                       ])))

# Drop extract1
w.add(dw.Drop(column=["extract1"], table=0, status="active", drop=True))

# Copy extract2
w.add(
    dw.Copy(column=["extract2"],
            table=0,
            status="active",
            drop=False,