Forum Discussion
Solved
Create a subset table from a fact table
I need to creat a sub set table with all the columns in the main table but filtered with value "A" in the Code column. I need all related rows in the coulmns to be able to add additional calculated columns in the filtered sub set table. I appreciate your help.
| Date | Code | Ind | Val |
| 1/1/2020 | A | NM | 20 |
| 1/6/2020 | B | BL | 40 |
| 1/20/2020 | A | NM | 60 |
| 2/15/2020 | A | CX | 80 |
| 1/5/2020 | C | DG | 30 |
New table:
| Date | Code | Ind | Val |
| 1/1/2020 | A | NM | 20 |
| 1/20/2020 | A | NM | 60 |
| 2/15/2020 | A | CX | 80 |
khaledSA ,
Can you an example of it ?
Maybe your column needs to be cleaned. Have you tried TRIM/CLEAN it on Query Editor ?
4 Replies
camargos88Community Champion
Hi Recardo,
I have tried that befroe but I get empty columns.
- camargos88
khaledSA ,
Can you an example of it ?
Maybe your column needs to be cleaned. Have you tried TRIM/CLEAN it on Query Editor ?
