cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
FlowHawk
New Member

Combine two columns from two tables

I have two completely unrelated tables. One is from a query, and one is a Date table that I created by function. The first has a list of company names:

Company A

Company B

Company C

Company D

 

The second has a dynamic list of dates from the last year as follows:

1/1/2018

2/1/2018

3/1/2018

4/1/2018

 

I need an output table as follows:

Column A - Column B

1/1/2018 - Company A

2/1/2018 - Company A

3/1/2018 - Company A

...

1/1/2018 - Company B

2/1/2018 - Company B

3/1/2018 - Company B

...

 

And so on. Because the second table is a date table, I cannot use the Query Editor. This seems to be simple, but I can't quite get it. Any help is very much appreciated!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

Re: Combine two columns from two tables

Hi @FlowHawk

 

Try

NewTable = CROSSJOIN( TableA, TableB)

View solution in original post

2 REPLIES 2
Super User III
Super User III

Re: Combine two columns from two tables

Hi @FlowHawk

 

Try

NewTable = CROSSJOIN( TableA, TableB)

View solution in original post

FlowHawk
New Member

Re: Combine two columns from two tables

Nailed it!

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors