topic Sync and Loop Table in QlikView

Sync and Loop Table

marcohadiyanto — Wed, 02 Feb 2011 04:20:32 GMT

hi all,

i have problem with my modeling after i add table target then show sync and loop.

i'm still confused about modeling, please help me.

thanks

deepakk — Wed, 02 Feb 2011 05:05:20 GMT

HI,

DO a force concatenation and combine TargetBranch table and Outlet_Temp into one.

marcohadiyanto — Wed, 02 Feb 2011 05:53:44 GMT

hi, thanks for your reply.

if i do concatenation, it still looping.

my problem is my table target is specified,

deepakk — Wed, 02 Feb 2011 05:59:52 GMT

hi Marco,

Soory I missed out one point.

YOu also need to combine the Product Table with Master_Temp using join keyword.

marcohadiyanto — Wed, 02 Feb 2011 12:53:41 GMT

Hi, I already concatenate them, but it not associate with other value. If I join them, value become multipicity.

Wed, 02 Feb 2011 13:59:07 GMT

HI macro,

I agreed with Deepak,

I think you are missing something.

because after concatenation and Join all syntetic keys will go and finally ur LOOP

deepakk — Thu, 03 Feb 2011 05:02:16 GMT

hi Marco,

Sorry I didnt get your point. As per our above discussion if we combine then we will have two table.

Yes there might be synthetic keys, which can be resolved. But our main aim is to avoid the loop.