Qlik Community

Qlik Sense App Development

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

Highlighted
Billy_u
New 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
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
Billy_u
New 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"

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
Billy_u
New Contributor III

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

i didn't understand very well

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)
Billy_u
New Contributor III

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

yes the name of files is ever different

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...
Billy_u
New 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?