Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

add a specific column to table in a data model

Hi everyone,

I have a data model based on Excel sheets.

In some of these sheets there is not a field (city) that is present in the others,

this field / column must always be in cell B: 2 in order to be consistent with the rest.

 Without touching excel manually how can I add this field to the script  where I don't have it and then get qvd that match, correctly?

 

thank you to everyone

8 Replies
Highlighted
Partner
Partner

Re: add a specific column to table in a data model

how are you loading these excel sheets? from the way you phrased it i am assuming you are doing wilcard load like *.xlsx or something similar.
if it is i dont believe there is a way apart updating the excel
Highlighted
Contributor III
Contributor III

Re: add a specific column to table in a data model

i'm loading with a automated procedure with a

load *

from "variable defined"

Highlighted
Partner
Partner

Re: add a specific column to table in a data model

as far as i know with automated load unfortunately you will need to add into excel .
is there any way to differentiate names of ones without the column? if so maybe you can split the load into 2
Highlighted
Contributor III
Contributor III

Re: add a specific column to table in a data model

i didn't understand very well

Highlighted
Partner
Partner

Re: add a specific column to table in a data model

Are the files with column missing named in any particular way (different from others)
Highlighted
Contributor III
Contributor III

Re: add a specific column to table in a data model

yes the name of files is ever different

Highlighted
Partner
Partner

Re: add a specific column to table in a data model

i dont think you get what i mean. My question is there a pattern to the names of files with column missing.
e.g. Most files are have a pattern for names like MyFiles05062019.xlsx, MyFiles04062019.xlsx etc
but files with the column missing has a different pattern NoCityFiles05062019.xlsx...
Highlighted
Contributor III
Contributor III

Re: add a specific column to table in a data model

I understand do you say to rename the files in the source dividing them those that don't have the field and those that have it?