I currently have several tables which I have concatenated in able to connect them to parameters. I have made sure to name all of the column names the same by using the AS function within the script. For example:
Load
"Period ID"
From Table 1
Concatenate Load
"Fiscal Quarter" AS Period ID
From Table 2
Concatenate Load
Period ID
From Table 3
The resulting output combines the columns in one and 3, but then creates a separate column "Table 1.Period ID" which lists the values from table 2. This means that when I select a quarter as a filter, the data from table one and 3 will load properly but the charts representing data from table 2 will say there is nothing to display.
I have also tried a join function but this was even more off. Each table that I am loading has 6 columns that are the same and about 2-3 that are different from the others (6 Tables in total that I am trying to concatenate). It seems that only the columns which had to be renamed will not properly combine.
