topic Different sources in different formats in QlikView

Different sources in different formats

Wed, 25 Nov 2020 16:16:04 GMT

Hi experts,

For my application I have source data from 2 different types of formats. One is excel which works fine and is my master it contains all the fields I need.

The 2nd source is a pdf document which I have converted to excel with a tool which lacks some fields. The Pdf has some necessary fields. I would also like to add another field with a name. Is it possible in qlikview or is the only way to add a new column manually and add name per every row or can Qlikview accomplish this and for every row add a following column with the name of "ap3"?

EDIT:

I added a picture of the excelsheet these 2 fields needs to be added for every row.. If you udnerstand

Re: Different sources in different formats

Anil_Babu_Samineni — Tue, 08 Nov 2016 09:19:54 GMT

Assume this

Source1:

Load Name, File, Sales1 From Source1;

Source2:

Load Name1, File1, Sales2 From Source2;

From this, You can add one more column like below

Load *,'ap3' as ap3 FROM Resident Source2

Re: Different sources in different formats

sunny_talwar — Tue, 08 Nov 2016 09:36:40 GMT

I think it would be 'ap3' as Name

Load *,

'ap3' as Name

FROM Resident Source2