Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

krithikarees
New Contributor III

Concatenate three tables

I have three tables with all same fields - except the for the field sign data , Which contains different amounts but same field name . how do I concatenate all these three tables into one table and have amount fields show up as three different fields.

Example:

Actuals:

Load

Account_Exp,

Profit center,

costcenter,

signdata

from

abc;

Budget:

Load

Account_Exp,

Profit center,

costcenter,

signdata

from

abc;

forecast:

Load

Account_Exp,

Profit center,

costcenter,

signdata

from

abc;

Thanks in advance.

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Concatenate three tables

Just renaming them like:

...

signdata as signdataActuals,

...

signdata as signdataBudget,

...

signdata as signdataForecast,

...

- Marcus

View solution in original post

1 Reply
MVP & Luminary
MVP & Luminary

Re: Concatenate three tables

Just renaming them like:

...

signdata as signdataActuals,

...

signdata as signdataBudget,

...

signdata as signdataForecast,

...

- Marcus

View solution in original post