Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

disparate source

Newbie here -

Is there a way to connect to 2 or more disparate table that are completely unrelated?  As I edit my script with two sql statements, I want them to be unrelated but QV continue to force a relationship between the two, how can I make them separate entirely.

RJG

5 Replies
eduardo_sommer
Partner - Specialist
Partner - Specialist

Probably, the two table have a column with the same name, forcing Qlikview to link them. You can use the command unqalify * before the load commands. The unqualify command changes the name of the columns, concatenating the name of the table in front of the column names. This will result in columns with unique names in both tables.

Eduardo

Anonymous
Not applicable
Author

Just to correct it, Qualify * will do the work instead of Unqualify.....

Regards

Nitin

eduardo_sommer
Partner - Specialist
Partner - Specialist

Of course. It's qualify. I made a mistake when I wrote my response above.

Thank you Nitin

Peter_Cammaert
Partner - Champion III
Partner - Champion III

You can also inspect the current (bad) relations using the Table Viewer (use Ctrl+T, it's a great tool) in QV Desktop. All connecting lines between the two tables should be eliminated.

If there aren't too many false relations created by QlikView, you can cut them by renaming the columns that cause these relations in only one of the two SQL statements. This is done by specifiying a new name immediatly after each offending column specification, like in

SQL SELECT "OriginalColumn1Name" "NewColumn1Name", "Column2", "Column3" ...

Best,

Peter

SunilChauhan
Champion
Champion

You can concatenate them and create a fact table and link both table to fact

Sunil Chauhan