topic Re: Script in QlikView

Script

Pujitha — Thu, 18 Jul 2019 16:14:10 GMT

Hi,

I have 4 files which I need to concatenate to one. In one file I have like

Name Opt loc Cod id dig Lb .Gop. ....... some other columns

code 0 0 24 1 exx ..... ..... .....

prof 1 0 43 2 xer .... ... ..

stud 0 0 34 3 iop .... ... ....

Another table:

loc Cod Lb id gop(as op) ..............here and so on other columns

diff data in Lb column

another table:

Et loc Cod Lb id

another table:

Et st status Lb id loc

I need to append all these tables to one pls let me know this clearly from start to end how to do. Please let me know asap

Re: Script

lockematthewp — Thu, 18 Jul 2019 16:50:21 GMT

After loading those files, QlikView will automatically connect them based on matching column names. If you want to remove some of the connections (like to remove synthetic keys), just change the script with the as keyword like:

Load [Name],

[Opt] as Whatever,

…..

Re: Script

Pujitha — Thu, 18 Jul 2019 17:50:29 GMT

Can you make it little clear. If I load all the files it will come as single file??

Re: Script

lockematthewp — Thu, 18 Jul 2019 19:46:39 GMT

They will still be 4 separate tables. But QlikView will automatically make associations between them wherever the column names match. You can load them all and then press CNTRL + T and it will show you a picture of how the tables are connected. There is really no need to put them all in one table as QlikView will pretty much treat it that way anyways.

Re: Script

Pujitha — Thu, 18 Jul 2019 19:49:30 GMT

I am getting synthetic keys. I did concatenate between tables. Even though the column name is same for some but data is different.

Re: Script

Brett_Bleess — Wed, 14 Aug 2019 13:56:37 GMT

Pujitha, check out the following Design Blog post link, I think it will help you get your head wrapped around the synthetic keys.

https://community.qlik.com/t5/Qlik-Design-Blog/Synthetic-Keys/ba-p/1472634

The other two functions that will likely come in handy to clean up the synthetic keys would be the following:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptRegularStatements/Qualify.htm

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptRegularStatements/Unqualify.htm

Hopefully that helps get you on the right track on this one.

Regards,
Brett

Re: Script

marcus_malinow — Wed, 14 Aug 2019 14:08:49 GMT

If you want the end result to be a single table, use forced concatenation

Table:

LOAD

[field list]

FROM [Source 1]

CONCATENATE (Table)

Load

[field list 2]

FROM [Source 2]

etc, etc.

Re: Script

Brett_Bleess — Wed, 14 Aug 2019 14:30:38 GMT

Duplicate thread, see the following for other posts: https://community.qlik.com/t5/New-to-QlikView/scripting/m-p/1604193/highlight/false#M378198

Regards,
Brett