topic Concatenating Multiple Tables in App Development

Concatenating Multiple Tables

Anonymous — Wed, 26 Sep 2018 19:11:06 GMT

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.

Re: Concatenating Multiple Tables

swuehl — Wed, 26 Sep 2018 21:20:59 GMT

Are you using a QUALIFY statement somewhere in your script?

Re: Concatenating Multiple Tables

Anonymous — Wed, 26 Sep 2018 21:45:33 GMT

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