Add 'total' name to all

[Anonymous]

Hi guys,

I'd like to add 'Name' to all records in load script.

MyFile:

LOAD respondentID,

     date,

     CleanedText_FTC_Purchase as CleanedText,

     [FTC_Purch concepts] as Concept,

     OSAT,

     OSAT_TOTAL_FTC_Purchase as "OSAT TOTAL",

     OSAT_STD_TOTAL_FTC_Purchase as "OSAT STD TOTAL",

     [Task Completion],

     POV,

     Product,

     [Type of mouse],

     [Type of keyboard],

     'Purchase' as Type  Resident FTC_Purchase_EXPORT;

Concatenate

LOAD respondentID,

     date,

     CleanedText_FTC_research as CleanedText,

     FTC_research_concepts as Concept,

     OSAT,

     OSAT_TOTAL_FTC_Research as "OSAT TOTAL",

     OSAT_STD_TOTAL_FTC_Research as "OSAT STD TOTAL",

     [Task Completion],

     POV,

     Product,

     [Type of mouse],

     [Type of keyboard],

     'Research' as Type  Resident FTC_research_EXPORT;

How can I do it?

Thanks,

[marcus_sommer]

I'm not sure if I understand it right. Mostly will be this done with a table-prefix created per qualify-statement - if you want instead a suffix you could use a rename-statement with mapping.

- Marcus

[Anonymous]

What I'd like to add it's a new variable which will  show from what source I took it.

Thanks,

[Anonymous]

"purchase" and "research" it's my text. I don't have them in the sources.

[sasiparupudi1]

what is the issue you are having? please provide sample data and the problem you are facing

[qlikviewwizard]

Hi,

Please attach the sample qvw with the data. Thank you.

[marcus_sommer]

If you are loading from files you could use file-functions like filebasename()  as Source to specify your source. By resident-loads or sql database loading you will to set this manually unless you used variables for the table-names which could be used instead the filebasename().

- Marcus

[Anonymous]

I have 2 files. I want to concatenate them and add a new variable which I called "Type" The "Type" variable should show from what the file I took.

[sasiparupudi1]

why dont you add an additional coulmn in your excel documents called type with the required values?

[Anonymous]

It's just an example. Original files I got from different sources.