Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
syedzee
Contributor II
Contributor II

Update Straight Table Record with user Interaction

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.

 

2 Replies
Durgadevikumar
Partner - Contributor III
Partner - Contributor III

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

 

Durgadevikumar
Partner - Contributor III
Partner - Contributor III

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