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

[naveen341]

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‌

[Clever_Anjos]

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

[naveen341]

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

[Clever_Anjos]

Don´t they have anything similar?

Column order at least?

[vishsaggi]

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.