topic Re: Concatenate in QlikView

Concatenate

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

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

;

Re: Concatenate

prma7799 — Thu, 28 Sep 2017 05:27:02 GMT

Try like this

Concatenate(Actauls)

CLosure:

'45' as Newton

Department

Start

End

From [../Department.XLXS];

Left join (CLosure)

Load * Inline

[

'LUNAR' as Netwon

;

Re: Concatenate

avinashelite — Thu, 28 Sep 2017 05:30:46 GMT

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

;

Re: Concatenate

jonathandienst — Thu, 28 Sep 2017 05:35:49 GMT

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 ]

Re: Concatenate

omkarvamsi — Thu, 28 Sep 2017 05:41:04 GMT

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

Re: Concatenate

smilingjohn — Thu, 28 Sep 2017 05:49:14 GMT

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

Re: Concatenate

avinashelite — Thu, 28 Sep 2017 05:50:08 GMT

Did you tried what is suggested earlier ???

Re: Concatenate

smilingjohn — Thu, 28 Sep 2017 06:09:07 GMT

Hi omkar

I want lunar under Newton field

Re: Concatenate

omkarvamsi — Thu, 28 Sep 2017 09:28:56 GMT

please try as below for Lunar

Concatenate(Actauls)

LOAD * INLINE [

Newton

Lunar

];