python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - conditional-formatting

How to use like condition in Conditional Split in SSIS

I am using conditional split to filter out the data from table. I have couple of conditions to check for. For example, In Email column, value should not contain ~ character and contain @ sign. Date of...
test-img

Nilesh

sql

sql-server

ssis

etl

conditional-formatting

Votes: 0

Answers: 1

Latest Answer

Add additional columns in your source query depending on your conditions and then use those columns in conditional split . SELECT CASE WHEN Email LIKE '%@%' OR Email L...
test-img

MetaData

How can I divide one variable into two variables in R?

I have a variable x which can take five values (0,1,2,3,4). I want to divide the variable into two variables. Variable 1 is supposed to contain the value 0 and variable two is supposed to contain the ...
test-img

rdummie

r

split

sum

conditional-formatting

Votes: 0

Answers: 4

Latest Answer

You can convert the variable to logical by testing whether x == 0 x <- c(0, 1, 0, 4, 3, 0, 0, 2) table(x) #> x #> 0 1 2 3 4 #> 4 1 1 1 1 table(x == 0) #> FALSE TRUE #> 4 ...
test-img

Allan Cameron

Remove duplicates in Column A when Column B = &quot;Value&quot; in power BI or DAX

I am having difficulties with PowerBI in removing duplicates from one column based on a condition on another column. My data is something like this Sample Data As you can see in the sample data, there...
test-img

Raj

powerbi

dax

powerquery

conditional-formatting

Votes: 0

Answers: 1

Latest Answer

In PQ (Transform) Group by ID For each subtable, if there is more than one row, select only the rows where Status=true let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromT...
test-img

Ron Rosenfeld

How to drop part of the values from one column by condition from another column in Python, Pandas?

I have real estate dataframe with many outliers and many observations. I have variables: total area, number of rooms (if rooms = 0, then it's studio appartment) and kitchen_area. "Minimalized&quo...
test-img

alpony

python

pandas

dataframe

conditional-formatting

outliers

Votes: 0

Answers: 1

Latest Answer

Clean mask1 = df.rooms > 0 mask2 = df.kitchen_area < 5 df1 = df[~(mask1 & mask2)] df1 area kitchen_area rooms price apt1 40 10 1 50000 apt2 20 0...
test-img

piRSquared

Posts

Questions

Blogs

Jobs