topic Re: Update Straight Table Record with user Interaction in QlikView

Update Straight Table Record with user Interaction

syedzee — Wed, 10 Jun 2020 14:07:25 GMT

Hi,

I have straight table loaded with data using excel file which has filed such as Customer Id, Customer Name.

My question is this can i have update existing customer Name with New Name for example I want to use input field to update the record or what is the best possibilities to do this task.

Customer Id Customer Name

1 Tom

2 Anna

Customer Id 1 , Name can be replace with Harry.

New data look like

Customer Id Customer Nmae

1 harry.

Re: Update Straight Table Record with user Interaction

Durgadevikumar — Thu, 11 Jun 2020 07:11:03 GMT

Hi,

Can you pls try this,

MapTable1:

mapping LOAD Customer Id,
Customer Name // The new updated file(which one has customer name harry)
FROM
[C:\Users\Desktop\top 10 sales.xlsx]
(ooxml, embedded labels, table is Sheet4);

Table2:

LOAD Customer Id,
ApplyMap('MapTable1',Customer Id,Customer Name) as Customer Name1 // The old table

FROM
[C:\Users\Desktop\top 10 sales.xlsx]
(ooxml, embedded labels, table is Sheet3);

Now applymap map the customer id with mapping table customer id and fetch the new updated name of the customer.

Hope it is helpful😊

Regards,

DurgadeviKumar

Re: Update Straight Table Record with user Interaction

Durgadevikumar — Thu, 11 Jun 2020 08:28:52 GMT

Hi,

Also use this,

A:
LOAD

Customer_Id,
Customer_Name
FROM
[C:\Users\770841\Desktop\top 10 sales.xlsx]
(ooxml, embedded labels, table is Sheet3);

B:
load
Id,
if(Customer_Id=1,'Harry',Customer_Name)as newname
Resident A;
Drop table A;

By,

DurgadeviKumar