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
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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: 
naveen341
Creator
Creator
‎2017-09-12 04:38 PM

Excel is the source to Qlikview dashboard Column names keep on changing

HI

Excel is the source to Qlikview dashboard Column names keep on changing every day and format also changes

Is there a Qlikview can handle these kind of errors.

Ex :day1 : Quality issue

Day 2: Quality iss

Day3: Quality Issues.

Regards,

Naveen

New to QlikView‌ QlikView App Developmentbps‌amz‌bqg‌

371 Views
0 Likes
4 Replies
Clever_Anjos
Employee
Employee
‎2017-09-12 05:05 PM

You should map all format and columns names possible changes and implement possible workarounds

Believe me, it´s a huge job.

It would be much easier to have a standard input

275 Views
0 Likes
naveen341
Creator
Creator
‎2017-09-12 05:14 PM
Author

In response to Clever_Anjos

that is not in our control Anjos.I get those spreadsheets from different vendors

275 Views
0 Likes
Clever_Anjos
Employee
Employee
‎2017-09-12 05:24 PM

In response to naveen341

Don´t they have anything similar?

Column order at least?

275 Views
0 Likes
vishsaggi
Champion III
Champion III
‎2017-09-12 05:24 PM

In response to naveen341

If the source file fields changes everyday it does not matter which tool or database you use you will have issues cause it will be the first point of data contact. As Clever suggested you need to figure out some standard before you automate this. 

275 Views