Search for a command to run...
Articles tagged with #learn-coding
Problem description & analysis: The Time field of a certain database table is time, and the time interval is sometimes greater than 1 minute. Task: Now we need to divide the data into windows every minute, fill in the missing windows, and calculate ...
Problem description & analysis: An invoice table in the SQL Server database has one amount for each project, and each project in the project table has multiple accounts, and the two are associated through ProjectID. # Invoices #Projects Task: Now w...
Problem description & analysis: The values in columns A and B are natural numbers, representing the start and end points of the array respectively: Task: Use the values in columns A and B to generate a string composed of a natural number array, and ...
Problem description & analysis: There is a column of serial numbers (No), as shown in the figure below: Task: Now we want to use the two numbers in each row to expand into continuous number intervals, like this: Solution: Use SPL XLL and enter the ...
Problem description & analysis: There is a data table. In this table, the products with the same name may have multiple colors. Task: Convert the data to the form as shown below, that is, arrange each type of product in one row, and then list the Na...
Problem description & analysis: Here below is a data table: Task: Group the data by Dept, and concatenate the names within the same group into the same row. Solution: Use SPL XLL and enter the following formula: =spl("=E(?1).group(Dept;~.(Name).conc...
