topic Re: add a specific column to table in a data model in App Development

add a specific column to table in a data model

Billy_u — Sat, 16 Nov 2024 20:43:23 GMT

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

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

dplr-rn — Wed, 05 Jun 2019 13:32:21 GMT

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

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

Billy_u — Wed, 05 Jun 2019 13:38:28 GMT

i'm loading with a automated procedure with a

load *

from "variable defined"

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

dplr-rn — Wed, 05 Jun 2019 13:41:45 GMT

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

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

Billy_u — Wed, 05 Jun 2019 15:15:30 GMT

i didn't understand very well

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

dplr-rn — Wed, 05 Jun 2019 15:17:12 GMT

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

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

Billy_u — Wed, 05 Jun 2019 15:18:07 GMT

yes the name of files is ever different

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

dplr-rn — Wed, 05 Jun 2019 15:22:09 GMT

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...

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

Billy_u — Tue, 11 Jun 2019 11:33:27 GMT

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?