topic Re: Load particular table from different user in QlikView

Load particular table from different user

gauthamchilled — Wed, 25 Nov 2020 16:16:04 GMT

I have a scenario like this.

I have a whole application with Dimensions and Facts. I loaded with Admin Rights.

Lets say I'm User A. After I load the file, I want to pass this file to another person in another country, lets say User B.

After User A reloads the whole application and pass it to User B.

User B wants to load some customer details which is confidential (User A dont have access to that dataset). Since the QVw already have customer id, when User B reloads the application only the customer information alone to be reloaded and joined with existing data model.

how can i do this?

Re: Load particular table from different user

Anil_Babu_Samineni — Fri, 10 Mar 2017 03:24:15 GMT

I didn't follow you correctly. May be helpful

https://community.qlik.com/thread/141181

Section Access (English)

Re: Load particular table from different user

gauthamchilled — Fri, 10 Mar 2017 03:47:07 GMT

Sorry Not helpful.

Re: Load particular table from different user

gauthamchilled — Fri, 10 Mar 2017 03:52:24 GMT

USER A is the owner of a dataset with customer id and dont have access to employee who works for customers.

USER B is having the access to employee who works for customer dataset.

After User A loads the application transfer the qvw file to another country.

USER B have to load the data (mapping customer id with employee) from his country so as to get the employee details in the same dashboard.

Add load appends the data to a table, whereas my requirement is to add a particular table and link it with the datamodel. Not sure how can i allow the USER B to load the mapping table alone in the existing qvw.

Re: Load particular table from different user

Anil_Babu_Samineni — Fri, 10 Mar 2017 05:03:57 GMT

May be Helpful, In fact, still not considerable from my end. You may recommend legends for new reply.

Load CustomerId, Country

From <Country1>

Load CustomerId, Country

From <Country2>

If userA has to create the data set for Country1 and then UserA tranfer that file to Country1. From here, Where you all transferring the files. I meant which server

If we need to match from One country to another country this will help you

ABC:

Load CustomerId, Country from Country1 Where Country = 'IND';

XYZ:

Load CustomerId, Country from Country2 Where Country = 'USA';

FinalTable:

Left Join(ABC)

Load *, ApplyMap(CustomerID,'ABC') as Country1 Resident XYZ

Drop Tables ABC, XYZ;

Re: Load particular table from different user

PaulVanSiclen — Fri, 10 Mar 2017 05:09:49 GMT

user B could use a 'binary load', here is the help file on that:

Is binary load supported in Qlik Sense ?

I employ this method often.

Re: Load particular table from different user

gauthamchilled — Fri, 10 Mar 2017 06:38:35 GMT

I need to use the same application. Is there any better solution?

Re: Load particular table from different user

adamdavi3s — Fri, 10 Mar 2017 09:58:16 GMT

Just use a partial reload for this.

Give user B a button which executes a partial reload to load their customer data.

Unless I am missing the point here?

ADD load can create new tables, however you do need to create a dummy 'shell' table for it to work with

As long as your code works it will be fine, try this out:

departmentdetails:
LOAD * INLINE [
Department,Multiplier
  ];

ADD LOAD * INLINE [
Department, Multiplier
A,  100
B, 200
C, 300
D, 400
];
IF IsPartialReload() = 1 THEN


EXIT SCRIPT
END IF
Transactions:
Load
'1' as TransCounter,
TransLineID,
TransID,
mod(TransID,26)+1 as Num,
Pick(Ceil(5*Rand1),'A','B','C','D','E') as Department,
Pick(Ceil(6*Rand1),'0','1','2','3','4','5') as Status,
Pick(Ceil(2*Rand1),'0','1') as OverdueFlag,
makedate(Ceil(2017-(3*Rand())),Ceil(12*Rand()),Ceil(28*Rand())) as OrderDate,
date(if(100*rand() >5,makedate('2017',Ceil(12*Rand1),Ceil(28*Rand1)),null())) as ShippedDate,
money(round(RAND()*25000,0.01)) AS Value;
Load
Rand() as Rand1,
IterNo() as TransLineID,
RecNo() as TransID
Autogenerate 10000
While Rand()<=0.5 or IterNo()=1;

Re: Load particular table from different user

gauthamchilled — Mon, 13 Mar 2017 01:35:46 GMT

Adam Devies,

My scenario is adding a new table (mapping).

For Eg:

User A:

Sales:

Load * inline

[

Country,Year,Sales,CustomerID

......

.....

];

Customer:

Load * inline

[

CustomerID,CustomerName,EmployeeID

.....

......

.....

];

User B hav below table:

Employee:

Load * inline

[

CustomerId,EmployeeId,Employeename,salary

.....

......

];

I cant use Add load which is for just concatenating the records, but there linking the customer table with employee table...

i just need a solution without using Binary load.

Please help

Re: Load particular table from different user

adamdavi3s — Mon, 13 Mar 2017 07:24:47 GMT

Did you actually try my example out?

Employee:

LOAD * INLINE [

CustomerId,EmployeeId,Employeename,salary

];

ADD LOAD * inline

[

CustomerId,EmployeeId,Employeename,salary

.....

......

];

IF IsPartialReload() = 1 THEN

EXIT SCRIPT

END IF

Sales:

Load * inline

[

Country,Year,Sales,CustomerID

......

.....

];

Customer:

Load * inline

[

CustomerID,CustomerName,EmployeeID

.....

......

.....

];

Re: Load particular table from different user

gauthamchilled — Tue, 14 Mar 2017 02:07:59 GMT

I cannot try because your add line statement is for the existing table...mine is new table and new columns. so it didnt work.

Re: Load particular table from different user

adamdavi3s — Tue, 14 Mar 2017 07:40:42 GMT

I'm sorry but you will have to explain yourself further.

The solution I have provided works for the example you have given me and could be adapted to work for any given scenario.