topic Re: How to add columns in QlikView

How to add columns

icaro_povoa — Fri, 12 Feb 2016 12:48:56 GMT

Dear all,

I am starting to create scripts with multiple sources, and noticed that some columns are not available in all the tables.

Is it possible to add columns directly in the script and fill them with a standard criteria without changing my data source?

I need to have things as Crop/Country/Season as a filter, but do not have all of them listed in some of my sources.( Because I have one file for each Crop/Country/Season)

Thank you very much

Re: How to add columns

sunny_talwar — Fri, 12 Feb 2016 17:48:43 GMT

Are they going to be static for all rows? or a condition based? You can use Mapping Load with ApplyMap() to be able to do this based on condition. For more help, please provide a sample.

Best,

Sunny

Re: How to add columns

icaro_povoa — Fri, 12 Feb 2016 18:02:15 GMT

Hi Sunny,

Yes they will be static. I need to create the column because I have 3 files.

- The first one I have a lot of information inclusive the column called CROP ( Corn and Sunflower)

- The second file is basically a database from my Corn team, so I only have information of corn, so we didn´t add the column "Crop" ( because will make no sense once we just have one crop)

- The third file is the same as corn, but for Sunflower.

What I need is to add on the files 2 and 3 the column CROP filled with Corn (File2) and Sunflower (File3), so I can create a script with the 3 files and use this column as a filter.

Hope it helps.

Thanks

Re: How to add columns

sunny_talwar — Fri, 12 Feb 2016 18:29:37 GMT

For static stuff, you can do this:

LOAD FieldName,

'Corn' as Crop

FROM Source1;

LOAD FieldName,

'Sunflower' as Crop

FROM Source2;

Re: How to add columns

icaro_povoa — Fri, 12 Feb 2016 19:04:23 GMT

Should I add this inside my current script from the Source 1? or Should I add this in the end of my scrip?

Like this??

LOAD

Country,

[Production Season] as ProductionCycle,

Field as PlotName2,

[Field Manager],

Supervisor,

FieldName,

'Corn' as Crop

FROM Source 1

or like this ????

LOAD

Country,

[Production Season] as ProductionCycle,

Field as PlotName2,

[Field Manager],

Supervisor

FROM Source 1

LOAD FieldName,

'Corn' as Crop

FROM Source1;

Thanks

Re: How to add columns

sunny_talwar — Fri, 12 Feb 2016 19:34:06 GMT

First way:

LOAD

Country,

[Production Season] as ProductionCycle,

Field as PlotName2,

[Field Manager],

Supervisor,

FieldName,

'Corn' as Crop

FROM Source 1