Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
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.
Are you using a QUALIFY statement somewhere in your script?
No, just the concatenate. The resulting table looks a little like this:
Period ID Table1.Period ID
Q1 -
Q2 -
Q3 -
Q4 -
Q1 -
Q2 -
- Q1
- Q2
- Q3