Keep/Remove Columns by Condition

#1

Hi,

is it possible to remove Columns by Condition?

KeepWantedColumns
KeepWantedColumns.png2368×1348 127 KB

KeepWantedColumnNamesWithValues.zip (8.0 KB)

It would be great, if the remove/Select Column Actions will get Partameters :slight_smile:

Can I do it with a trick (Rename by lookup …)

Regards,
Adrian

Still no Keep/Remove Columns by Condition?
#2

Hi Adrian,

you can already do this with EasyMorph. You can use the “Table metadata” action to produce a list of columns, filter it as necessary (e.g. using a condition), and the use the “Select by lookup” action to keep only the necessary columns.

I’ve updated your example to work like that.

KeepWantedColumnNamesWithValues (2).zip (8.3 KB)

image
image.png1046×587 18.4 KB

Still no Keep/Remove Columns by Condition?
#3

Hi Dmitry,

really great, thanks :+1::blush:

But now i have another problem in my process if i want to stay generic :woozy_face:

Only certain rows should be returned for one wanted column ("where WantedCol1=‘WantedVal1’)

The table should be filled down for the respective value. Somehow I can’t get there

is it possible to “filldown” the wanted Columns without specifying the column name, so that the Outputable looks like this picture

WantedOutputTableWantedVals
WantedOutputTableWantedVals.jpg2646×889 190 KB

That would be great because it would be the solution for my last post:

best regards and thanks again,

Adrian

#4

In this case the “Iterate column” action should help.

See the updated example below.
KeepWantedColumnNamesWithValues (3).zip (8.8 KB)

#5

Hi Dmitry,

I will try this. Thank you for this great support :clap::pray:

Best regards,

Adrian

#6

You’re welcome :slight_smile:

#7

Hi Dmitry,
unfortunately it don’t works.
The “generic Filldown” should start after the first match of “WantedVal1” and only Rows with “WantedVal1”. So WantedVal1 (or “WantedVal2”) should be a generic Filter in Filldown-Iteration.
Your solution gifs me OutputTable in Top but it should be the bottom one.
Sorry i was 3 days out, Therefore I could test only now.

KeepWantedColumnsStartsWithWantedValues
KeepWantedColumnsStartsWithWantedValues.png2229×916 316 KB

regards,

Adrian

#8

Hi,
here another example of the same problem.
I would like to fill the column with filldown, but only if a certain criterion is met.

In the example, only the area should be filled with the value until the criterion is no longer met or changes (only Data in Green Box should me modified)

FillDownDepending
FillDownDepending.png2043×1564 155 KB

FillDownFromAboveDependingValue.morph (4.3 KB) FillDownFromAboveDependingValue.zip (9.9 KB)

I hope this example is better for understanding my Problem.

best regards,

Adrian

#9

How about this one?

FillDownFromAboveDependingValue (2).zip (10.2 KB)

#10

Hi Dmitry,

it works, thanks. I also tried with filldown, but dont’t wanted to change existing data. But it should work, because data is rewritten to old value after filldown. :relaxed:

By the way. I sometime miss a “previous” or “above”-Funktion :wink:
Is it planed?

best regards and thanks again,

Adrian

#11

Above/below values can be obtained using the “Shift column” action.

#12

ok, thank you, i’ll test it :+1: