Create a row based on a condition (column value)

I have a table that contains the following data;

EmpNo | GivenName | Preferred name
---------------------------------
1 | Paris | Paris
2 | Ashley | Ash

I'm trying to get an exit where, if the First name and Preferred name the values ​​are the same, so the row must be returned as is, but if they are different, it must be returned twice (if possible, the twice returned row must be NULL in Preferred name in the first case and First name a NULL in the second). Something like that:

EmpNo | GivenName | Preferred name
---------------------------------
1 | Paris | Paris
2 | Ashley | NO
2 | NULL | Ash

I do not know where to start. I've tried using the CASE statement and FULL OUTER JOIN to no avail. I've also tried using the code below, and he gives me the answer to the first part of my question:

TO SELECT [EmpNo]
      ,[GivenName]
      ,[PreferredName]
OF [Emp] E
OR [GivenName]= [PreferredName]
UNION ALL
TO SELECT [EmpNo]
      ,[GivenName]
      ,[PreferredName]
OF [Emp] 

to hide rows in Google Sheets based on the value of the cell in another row

I'm trying to build a spreadsheet in Google sheets with a checkbox that will hide and display lines 5 through 60.

My checkbox is in cell A4, and when this box is checked, cell A4 says "hide" and cell A4 not checked indicates "display". I've saved two macros to hide and display lines 5 to 60 and have copied the code from each to make my functions hide and show. Now, I'm trying to write an onEdit () function that will make everything work, but I'm out of my element. Any help is greatly appreciated.

Here is the code I have up to now:

hideRows5to60 () {function
var spreadsheet = SpreadsheetApp.getActive ();
spreadsheet.getRange (# 5: 60 & # 39;). activate ();
spreadsheet.getActiveSheet (). hideRows (spreadsheet.getActiveRange (). getRow (), spreadsheet.getActiveRange (). getNumRows ());
spreadsheet.getRange (61 61: 61)). activate ();
};

function showRows5to60 () {
var spreadsheet = SpreadsheetApp.getActive ();
spreadsheet.getRange (& # 39; 4: 61 & # 39;). activate ();
spreadsheet.setCurrentCell (spreadsheet.getRange (& # 39; A61 & # 39;));
spreadsheet.getActiveSheet (). showRows (3, 58);
};

onEdit function () {
var ss = SpreadsheetApp.getActiveSpreadsheet ();
var s = ss.getSheetByName (& # 39; Duct Leak & # 39;);
var cellSh = s.getRange (& # 39; A4 & # 39;). getValues ​​();
}
if (cellSh = "hide");
{
showRows5to60 ();
}
if (cellSh = "hide");
{
hideRows5to60 ();
}

I have to buy ads from websites based in Poland

Advertisement

you do not do it?

Advertise almost everything here, with CPM banners, CPM mail ads, and CPC context links. You can target relevant areas of the site and show ads based on the geographic location of the user, if you wish.

Starts at just $ 1 per CPM or $ 0.10 per CPC.

Padma Aon Prakasha

Padma Aon Prakasha:

Padma Aon is an author of wisdom, a creator of vibratory media, a visionary pioneer and the public.
speaker bringing together ancient wisdom and modern science. Books, music and
Multimedia is derived from the traditions in which it was initiated.

Padma Aon Prakasha Books:

They include: the power of the shakti, wisdom of the womb, sacred relationships (inner traditions),
The master plan of Christ, The Nine Eyes of Light: The Keys to the Ascension of Egypt (NAB / Random House),
Dimensions of love (O Books). Since 1997, he has presented, lectured and taught in 20 countries around the world.

Padma Aon Prakasha Music:

Padma is a master of vibratory medicine by sound, translating the art and science of
vibration to create moving immersions and alchemicals. A music producer distributed around the world,
Padma performs around the world with two albums for Sub Rosa / BMG: Rhythmic Intelligence and
Song of Light as Resident DJ at Talvin Singh's Revolutionary Indian Music Fusion Night
Anokha at the legendary Bluenote Club, Hoxton.

Padma Aon Prakasha Videos:

The Life Cycles album accompanies the book Womb Wisdom, voted one of the Top 30 Spiritual Artists
books you need to read. The Souls Birth with Dr. Alex Theory and Kristin Hoffman merges the
Psychoacoustic frequency science for pregnancy and birth with Nada Yoga in Sanskrit and Hebrew.

Padma Aon Prakasha Media:

His television work consisted of co-discovering the first mummified Tibetan lama for "Mystery of the
Tibetan Mummy, & # 39; (Discovery Channel 01), and narrating Peabody winner, Stephen Olssen
documentary "Sounds of the Soul" on the Fes Festival of World Sacred Music, presented at
Cannes and SunDance.

Padma Aon Prakasha Events:

As a multimedia producer, he has created original music and visual content based on the sacred world.
venues for the Youth Olympic Games in Moscow and the "Project ONE", which has been presented in theaters and festivals
in the United Kingdom, the United States and New Zealand. He is currently creating music and audio for a revolutionary
Meditation App.

Padma creates from the fruits of his many travels and direct experiences in many worlds, Eastern and Western.
Padma supports the environment by leading large groups on carefully selected transformation projects.
Travel to cultural and sacred sites around the world in 15 countries over 20 years on 5 continents.
He appeared on BBC Radio One, The Times of India, Variety Magazine, Spirit & Destiny, Kindred Spirit,
Dreamland Radio, XLR8R and Straight No Chaser among many others.

Padma Aon Prakasha Contact:

Facebook: Padma Aon Prakasha
Twitter: Padma Aon Prakasha

LinkedIn: Padma Aon Prakasha
YouTube: Padma Aon Prakasha

.

Questions about the Google Forms drop-down list based on the previous drop-down list selection

The majority of the questions I've found regarding Google Forms referencing the drop-down list based on another drop-down list selection (cascading), are directed to Google sheets or do not receive an answer. . The last date I found an "answer" was the one that gave (which was Google Sheets, not Google Form), it was in 2018.

algorithms – Clustering of point clouds based on a similarity less than $ O (n ^ 2) $

I do not know if this is the right place to ask this question, but that's it.

Suppose I have a set of 2D points data including face landmarks and want to group them according to the similarity in order to be able to refer to a notion of "prototype". a facial expression.

As a measure between one set of points and another, I could use a sum of Euclidean distances.

Is it possible to get a set of prototypes without going through the landmarks? $ O (n ^ 2) $ time?

To better explain what I think, suppose I process a video frame by frame.

I start with the landmarks of the first image, and put it in my prototype list because I have no other reference.

Then, for each next image, I compare it to the first "prototype". If it's below a certain similarity threshold, I guess it's not unique enough and skips it. Therefore, until I find a set of quite different landmarks, now I have two "prototypes".

From that moment, I have to perform the similarity check with two "prototypes", etc.

Another caveat is that I would also like to be able to store the "prototype" that the current frame fits the most.

I will also have to make a second pass in a second clip for a similar correspondence with the "prototypes" identified during the first pass.

Is there a more effective way to do this, other than the naive approach?

email – Why am I getting spam after setting up postfix to redirect incoming mail to another user based on the recipient's address?

Up to here my main.cf contained mainly two lines:

local_recipient_maps =
luser_relay = mrjoe@mydomain.com

These settings are responsible for delivering all emails sent to any address in my domain, such as random_string@mydomain.com to my real account mrjoe@mondomaine.com. It worked and I only received emails from websites on which I signed up with any of my unlimited aliases.

I realized that I did not want to receive all these emails, so I had the idea of ​​deleting e-mails sent to a particular alias instead of blocking a particular sender. In this way, I can protect myself from any future junk mail and make this nickname disabled.

To bring this idea to life, I removed the two previous lines of main.cf and added the following:

virtual_alias_maps = pcre: / etc / postfix / virtual_alias

the virtual_alias the file has the following content:

/^((?!!(blacklisted_address|another_blacklisted)@).)*$/ mrjoe@mydomain.com

This configuration redirects all emails sent to addresses other than blacklisted_address@mydomain.com and another_blclisted@mydomain.com at the specified actual address mrjoe@mondomaine.com.

It works, e-mails sent to the listed addresses are not delivered to my inbox. The problem is that now I have started receiving hundreds of spam emails, none of which I received before.

Here is an example of such a spam message:

From secretariat@solid-app-api.be Wed 29 May 01:23:10 2019
Way back:
X-Original-To: mrsnorah11@gmail.com
Delivered to: mrjoe@mydomain.com
Content type: text / plain; charset = "iso-8859-1"
Content-Description: Body of the message
Subject: 21.21.21.21 // my IP address here
recipients
From: "Agent MacLeod"
Date: Tuesday 28 May 2019 16h23h10 -0700
X-UID: 1194
Content length: 3686
Status: RO

The question is: Why did I start receiving hundreds of spam emails after making the changes described above? How is it possible that now messages with X-Original-To header different from @ mydomain.com are delivered to my domain?

For now, I've brought back the previous configuration and I'm not receiving spam anymore. Clearly, this is not an acceptable solution.

Trigger workflow based on updating column values ​​in the SharePoint list

I have a SharePoint Online list with cases that staff must review regularly. When the case review is complete, staff selects "Finish" from a drop-down menu in the field titled Review Case. I'm trying to create a data feed that sends an email to a specific group when an item has that field labeled "Case Analysis" marked "Completed." I've looked at some templates, but I do not see how to specify that, when a field is changed to a specific value, an email must be sent. I am very new on SharePoint Online. Does anyone know how to do that?

Thank you.

sharepoint online – Triggers a workflow based on the status of a column

Is it possible to trigger an approval flow based on the status of a column in a SharePoint list?

For example. If column A = Value X —> Trigger Workflow.

If column X is anything other than X, do not fire the stream.

Basically, I want to create a trigger button for the stream.

Thank you!