547 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
1
answer
48
views
How to properly fill stock data during suspension periods?
Sharing a common DolphinDB use case and solution for data processing.
I'm working with stock trading data and facing a common but tricky issue. My dataset only contains records for days when actual ...
0
votes
1
answer
26
views
Is there a HQL condition where one object of a set is in a many-to-many relationship in 2025?
I have a Task with a @ManyToMany referenced roles, which specify roles a user must have at least one of, to perform the task. The HQL search should therefore find all tasks that have at least one of ...
2
votes
4
answers
340
views
How do I cross join two, multi-column tables in Google Sheets — without string hacking or Apps Script?
(I will post my own answer, but I want to pose the question for the sake of others in a similar situation; and to encourage alternative answers.)
Sometimes I have two tables and I need to cross join ...
1
vote
2
answers
107
views
Is sub-select necessary when using jsonb_to_recordset
I have been given the task of importing data from a 3rd party. Not knowing what the data would look like, I imported it into a JSON field in a PostgreSQL table. Now to make things easier, I want to ...
2
votes
4
answers
891
views
How to get the cartesian product (cross join) of two sets via Excel Formulas
I need to get the cartesian product of two "sets" via Excel 365 Formulas (not VBA, not Power Query). For instance, my two sets are the two left tables, and the expected cartesian product is ...
3
votes
2
answers
149
views
Polars cross join without reversed or equal entries
I'm joining two identical columns and am only interested in combinations (not permutations). Currently, I can perform a full cross-join and, subsequently, filter out the unwanted rows.
import polars ...
2
votes
1
answer
82
views
Why is the count different for cross join in Pyspark w or w/o join condition?
dfj3 = spark.createDataFrame(
['a','b','b'],StringType()
)
dfj4 = spark.createDataFrame(
['c','d','e'],StringType()
)
dfj3.join(dfj4).count() // #crossjoin, count = 9
dfj3.join(dfj4,dfj3....
-1
votes
1
answer
66
views
CROSS-JOIN not all rows in result
I am a beginner and I have this problem. I have two tables:
date table
a data table
I want to join all the rows from the first table with all the rows of the 2nd table ie cross join. After writing ...
0
votes
1
answer
101
views
Create a rowID / identity column in a cross-join subquery
I have a table with some of the combinations of two ids. I need to create a unique id for each other combination. Since some combinations already exist, I can't just use an identifier column.
The ...
1
vote
1
answer
125
views
Splitting columns of type MAP(int, Array) by other array column
Let's assume that I have a table containing four columns
ID_list array(int)
name_list array(string)
profile_scores map(int, array(map(int, float)))
...
1
vote
0
answers
58
views
How can I CROSS JOIN but limit dates on a unit-subunit basis?
I have inventory information for various warehouses for various items. The first available date of each each item varies by warehouse. I'd like to compute average seven-day inventories for each ...
-2
votes
1
answer
409
views
How to join two tables in MySQL using specific columns? [duplicate]
I want to write a query to get the customer name and product name order by first name.
I have two tables in my MySQL database, let's call them customer details table and product detail table. Each ...
1
vote
1
answer
232
views
How to resample an SQL database
I have a dataset which looks like below:
ITEM CITY START_Y START_W FIRST_USE_Y FIRST_USE_W VALUE
A NEW YORK 2023 30 2023 32 15000
A ...
-1
votes
3
answers
323
views
Repeat Value for Every Instance of Another Value in Excel without using Power Query
I have about a thousand products in a table. In another table, I have 33 price contracts. I need an instance of each product for every contract.
For example, if I had the 4 following products:
product
...
0
votes
1
answer
61
views
reducing redundant product from SQL cross join
I was stepping through a common SQL exercise and ran into an annoyance. Question is whether you have a better solve than mine below. The initial problem was "find all the coordinate sets on a ...
user avatar
user1844086