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 .... ... ....
loc Cod Lb id gop(as op) ..............here and so on other columns
diff data in Lb column
Et loc Cod Lb id
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
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:
[Opt] as Whatever,
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.
Pujitha, check out the following Design Blog post link, I think it will help you get your head wrapped around the synthetic keys.
The other two functions that will likely come in handy to clean up the synthetic keys would be the following:
Hopefully that helps get you on the right track on this one.
If you want the end result to be a single table, use forced concatenation
FROM [Source 1]
[field list 2]
FROM [Source 2]
Duplicate thread, see the following for other posts: https://community.qlik.com/t5/New-to-QlikView/scripting/m-p/1604193/highlight/false#M378198