Data model issue

[deepakqlikview_123]

Hi All,

PFA.

I am not able to associate the table AR_VarianceSummary and BU_HIER_D_Movement.

Can you please suggest how should i handle it Moreover plz suggest how should i avoid synthetic keys

[vishsaggi]

It says access denied when trying to open your document. Do you have section access in this?

[enriquem]

We can't open your file, reupload it!!

[deepakqlikview_123]

Hi All,

PFA.

I have removed section access.

thanks

[deepakqlikview_123]

Experts,

Can you please suggest on this

Thanks

[enriquem]

Hi,

I will suggest you to use the "Qualify" and "Unqualify" keyword to put a prefix in the AR_VarianceSummary fields and in the another tables that create you the synthetic keys.

Qualify *;

// your load table code

Unqualify *;

Here I put you some help about the qualify, because if you don't wanted to rename some field you must put just the field to rename in the qualify.https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/ScriptRegularStatement...

And to the question in this thread, I must said you that the 2 tables are relationship by the Comp_HierID.

Regards.

[deepakqlikview_123]

But after using that results has been changed. It is giving wrong results.

Thanks

[enriquem]

This can be because you don't create a good relationship of your data. You must put the same name to the field that you wanted like a relationship.

I don't know the proposal of your data, and how you wanted to mine your data, so I can't help you to build your data model.