Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

Concatenate

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

;

1 Solution

Accepted Solutions
omkarvamsi
Creator
Creator

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


View solution in original post

8 Replies
prma7799
Master III
Master III

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
Partner - Champion III
Partner - Champion III

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 ]

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
omkarvamsi
Creator
Creator

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
Specialist
Specialist
Author

Hi Jonathan,

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

concatenate.PNG

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
Specialist
Specialist
Author

Hi omkar

I want lunar under Newton field

omkarvamsi
Creator
Creator

please try as below for  Lunar

Concatenate(Actauls)

LOAD * INLINE [

    Newton

    Lunar

];