Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to generate a matrix table with two columns:
Partcode , Date
I have the table of partcodes and I want to add a series of dates to each partcode record between a mix and max date.
So I start with a table containing just partcode,
A
B
C
D
etc..
and end up with two columns...
A, 2024-04-01 - this will be a Date() field but wanted to show the date so it doesn't confuse Americans 😉
A, 2024-04-02
A, 2024-04-03
B, 2024-04-01
B, 2024-04-02
B, 2024-04-03
C, 2024-04-01
C, 2024-04-02
C, 2024-04-03
etc..
I know how to generate a table of dates but I just can't work out how to join the two!
Just write "Join" between the two tables:
Just write "Join" between the two tables:
So obvious now you've mentioned it!
😁 'Embarrassed Emoji'
Thanks for helping