Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Create a database with many excel files

Hi I want to create a database with n excel sheets whose fields have same name
I only add a new column "Version" with the date of the respective sheet

But Qlik is a bad guy and rename my tables

I dont want name fields like [sheet1.ID] [sheet2.ID] [sheet3.ID]

I wants [ID] [ID] [ID]

In my calculations I use set analysis to find monthly/weekly variations

sum ({< [Version]={' '}>} Value) - above(sum(Value))

Then I need n sheets with [Version] [Value] fields with the original name, not this [sheet1.Version] [sheet2.Version]

I can edit the script LOAD and delete all the "as [sheet1.ID]" it WORKS

But I want a method to Add many sheets in Qlik and it recognize my goals and will name all fields equally.

Now I only know how to Add sheet per sheet one per time

Please help

I searched the forum and only have found answers about join tables I want to separate them, but with original Fields names.

Labels (1)
0 Replies