Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have 2 tables. Let's call them A and B. All of these tables are Mutually Exclusive with the same set of metrics. Let the Metrics be M and N.
This is my Load Script:
[Table A]:
Dimension 1,
Dimension 2,
Metric M,
Metric N
[Table B]:
Dimension 3,
Metric M,
Metric N
As you can Observe here, Qliksense will join them automatically. But these are 2 different sets of data that I am fetching from different sources. How do I load without Join or Concatenate?
Qlik Sense creates an association for any pairs of fields in 2 tables that have the same name. You can prevent this automatic association by aliasing the fields (LOAD [Metric M] AS [Metric M1]... for example).
You can also use Qualify command to prefix filed names with table names, see https://help.qlik.com/sv-SE/sense/June2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularS...
Hope this helps,
BR,
Vu Nguyen
Qlik Sense creates an association for any pairs of fields in 2 tables that have the same name. You can prevent this automatic association by aliasing the fields (LOAD [Metric M] AS [Metric M1]... for example).
You can also use Qualify command to prefix filed names with table names, see https://help.qlik.com/sv-SE/sense/June2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularS...
Hope this helps,
BR,
Vu Nguyen