Concatenate

[smilingjohn]

HI ALl,

How do We concatenanate a table within the table which is already concatenated with another table .

Iam trying to do the the below logic but its not working .

Is there any way to do this ? or its not possible to add ...

I cannot add 45 and lunar as Newton because there has to be a unique field ..

Concatenate(Actauls)

//CLosure:

'45' as Newton

Department

Start

End

From [../Department.XLXS];

Concatenate(Closure)

Load * Inline

[

'LUNAR' as Netwon

;

[prma7799]

Try like this

Concatenate(Actauls)

CLosure:

'45' as Newton

Department

Start

End

From [../Department.XLXS];

Left join (CLosure)

Load * Inline

[

'LUNAR' as Netwon

;

[avinashelite]

Use the main table name while doing the concatenation

Try like this

Concatenate(Actauls)

//CLosure:

'45' as Newton

Department

Start

End

From [../Department.XLXS];

Concatenate(Actauls)

Load * Inline

[

'LUNAR' as Netwon

;

[jonathandienst]

You can concatenate freely as many times as you like. I don't know what you mean by "because there has to be a unique field" - there is no such constraint for a concatenate. I think you may be confusing that with the associations or joins.

The code you posted does not have a valid INLINE load, so unless these are typos you will get errors - no header line and no closing ]

[omkarvamsi · Accepted solution]

Hi John,

write concatenate(Actuals) above every table which you want to concatenate with Actuals.

Reason:

why Concatenate(Closure) wont work is because of Closure table will be concatenated with Actuals.So Qlikview couldn't able to see Closure table name which in turn brings you error.

Concatenate(Actauls)

//CLosure:

'45' as Newton

Department

Start

End

From [../Department.XLXS];

Concatenate(Actauls)

Load * Inline

[

'LUNAR' as Netwon

Regards

Om

[smilingjohn]

Hi Jonathan,

Please find the screenshot of the script iam trying to do ...

I want to ad One more field into the " Dimen" Table . which is called Newton.

I cannot add 543 as Newtone

and 'Lunar' as Newton within tha same Table ...( as there should be unique fields ) therefore iam trying to add inline table ..

I hope i am clear ..

Please guide me ..

Thanks

[avinashelite]

Did you tried what is suggested earlier ???

[smilingjohn]

Hi omkar

I want lunar under Newton field

[omkarvamsi]

please try as below for  Lunar

Concatenate(Actauls)

LOAD * INLINE [

    Newton

    Lunar

];