Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two main tables; fg_satspd and fg_satssk. fg_satsppd is order table and fg_satssk is the table where complaint records are kept. These tables mean different things. They have no unique fields. But I want to see, for example, how many complaints were received and how many orders were received on 01.02.2024, all together in a table. I created a master calendar to select 01.02.2024 as the date once.
I made a connection between this tables. These tables have date fields. I created a master calendar for these date fields. And that's where I made the connection.
but there is a table that I need to connect from the store code field that is in both tables. This table is fg_chschk.
For example, when I select the store and date;
Leaving store A in 2023. Order and complaint arrived?
How do I establish relationships between these tables?
You can concatenate tables fg_satspd & fg_satssk and link this concatenated table with master calendar on basis of date field and link the same with fg_chschk on the basis of store code.
But while concatenating, make sure to add a unique flag field in both tables to identify table source of the data
Regards,
Aditya
Table fg_satspd and fg_satssk have no fields in common. How do I concatenate it?
You can force concatenate them as they have common date & store code fields.
Regards,
Aditya