Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2017-11-23 12:52 AM

How to change a particular column to fetch data for dashboard

Hi

I have following excel file for store details in which firstly I was using ETPCode To fetch the Data But since I want to automate my report so I have decided to have SapCode in my incremental load ( a view is being created in database in which Sapcode is being added so that now there is no requirement of ETP code)

Now In my script I want to make changes so that there is no use of ETPCOde means Mapping of SAPCode and ETPcode is not required) Data will be only fetched using SAPCODE

Store_MAPPING(below image)

Following script is attached. Please help me where should I make changes in  the script on the basis of given above scenario new1.png

Preview file
25 KB
243 Views
0 Likes
0 Replies