Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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
What I'd like to add it's a new variable which will show from what source I took it.
Thanks,
"purchase" and "research" it's my text. I don't have them in the sources.
what is the issue you are having? please provide sample data and the problem you are facing
Hi,
Please attach the sample qvw with the data. Thank you.
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
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.
why dont you add an additional coulmn in your excel documents called type with the required values?
It's just an example. Original files I got from different sources.