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: 
Anonymous
Not applicable

how to join 3 different data sets without creating a loop

Hi everyone.

My table viewer looks as follows:

2015_08_12_08_37_18_pepqv2_Remote_Desktop_Connection.png

Now what I would like to do is to join SK Day No with Filedate without creating a loop.

Is this possible? Is it okay to have a loop like that?

Any help will be appreciated.

4 Replies
Not applicable
Author

Hi,

If you join two tables, the two tables will become a single table, in that case there wont be any chance of a loop formation.

Anonymous
Not applicable
Author

I'm not talking about joining tables to make 1 table.

I'm talking about linking seperate loads, as displayed in the picture above

jonathandienst
Partner - Champion III
Partner - Champion III

This article explains ways of handling multiple dates and calendars:

Canonical Date

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

Hi,

Please read the attached document.