Question

Room: Room # of Guests. For example, if there are two guests with the last name of West staying in the Coolidge room, the guest ID would be "West Room: Coolidge 2" without the quotation marks. Use the CONCAT (or CONCATENATE) function. Reference the Guest's Last Name, Room, and # of Guests in your function. Pay close attention to the spaces in the Guest ID. Copy and paste the function down the column to create the "Guest ID" for the other transactions.

Name: room room of guests for example if there are two guests with the last name of west staying in the coolidge room the guest id would be west room coolidge 2 without the quotation marks use the 05196
Uploaded: 2023-11-10T02:27:34-08:00
Duration: 2 min 14 s
Channel: Akash M
Description: room room of guests for example if there are two guests with the last name of west staying in the coolidge room the guest id would be west room coolidge 2 without the quotation marks use the 05196

          Room: Room # of Guests. For example, if there are two guests with the last name of West staying in the Coolidge room, the guest ID would be "West Room: Coolidge 2" without the quotation marks. Use the CONCAT (or CONCATENATE) function. Reference the Guest's Last Name, Room, and # of Guests in your function. Pay close attention to the spaces in the Guest ID. Copy and paste the function down the column to create the "Guest ID" for the other transactions.

room room of guests for example if there are two guests with the last name of west staying in the coolidge room the guest id would be west room coolidge 2 without the quotation marks use the 05196

Added by Angela P.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Akash M

11/10/2023

Step 1

Step 1: Identify the columns in the dataset that contain the Guest's Last Name, Room, and # of Guests. Show more…

Show all steps

Thanks for your feedback!

Room: Room # of Guests. For example, if there are two guests with the last name of West staying in the Coolidge room, the guest ID would be "West Room: Coolidge 2" without the quotation marks. Use the CONCAT (or CONCATENATE) function. Reference the Guest's Last Name, Room, and # of Guests in your function. Pay close attention to the spaces in the Guest ID. Copy and paste the function down the column to create the "Guest ID" for the other transactions.