Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I have met some issue when I trying to set table to get both of current month's value and previously month's value.
For example, I have 3 tables, namely table A, B, and C
Table A
A.Site | A. Snapshot | A.Customer | A. Site Key |
China | 20190630 | AAA | 1 |
US | 20190630 | BBB | 2 |
UK | 20190731 | CCC | 3 |
Table B
B. Site | B.Snapshot | B. Customer Name | B.other fields |
Australia | 20190630 | DDD | 1 |
US | 20190430 | AAA | |
China | 20190430 | CGD | 3 |
Table C
C.Site | C.Snapshot | C.Customer Name | C.Customer ID | C.Other fields |
India | 20190531 | XXX | cd123 | XXXXX |
In addition, there is a key of those table, the 'Reporting Period' which equals left 6 char of the snapshot, i.e. 'YYYYMM' 201906
And now, we are developing one more table (a status summary table) to show whether each site and the current reporting month has records in those tables, and please note, a same uploaded file, for example, document loaded 201906, will contain 201906 data for table A,B and 201905 data for table C.
For example, we want to check which site has value in which table in selected Reporting Period, when I selected Reporting Period as 201906, column 'table A' and 'B' will show 'Y' if the site has value when '201906', and column 'Table C' will show 'Y' if the site has records when '201905' (previously month).
Table A | Table B | Table C | |
China | Y | ||
UK | |||
US | Y | ||
Australia | Y | ||
India | Y |
Do you have any idea to achieve the requirement? or could you please give me some idea about it?
Any help will be appreciated, Thanks a lotttt!
Hi,
I have done this by concatenating the tables and giving them flags, if you don't want to concatenate, you will have to make link table to do the same task, rest all will be same.