Different sources in different formats

[#1]

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

[Anil_Babu_Samineni]

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

[sunny_talwar]

I think it would be 'ap3' as Name

Load *,

          'ap3' as Name

FROM Resident Source2