Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am writing the below thing in my script. As per my knowledge this will create a dummy table with data.
LOAD * INLINE [
zip_code
123456789
112233445
111222333
];
But can I manipulate or access this data.
For example as per a discussion going on how to extract the first 5 numbers form a zip code(zip1) and last 4 numbers(zip2).(I want to create a table with zip1 and zip2 as my columns)
Please let me know how can i achieve this.
Thanks,
Sujeet
Inline just means that the data is specific inline directly after the INLINE keyword between square brackets. It loads data in a table just as a load from a qvd file or from an
excel file does.
Try:
ZipTable:
LOAD *,
left(zip_code,5) as zip5,
right(zip_code,4) as zip4
INLINE [
zip_code
123456789
112233445
111222333
];
Hi
tmp:
LOAD * INLINE [
zip_code
123456789
112233445
111222333 ];
load
zipcode as zip
left (zipcode ,5) as zipcode5
right zipcode,4) as zipcode 4
resident tmp;
drop table tmp;
Thanks for the explanation.
--Sujeet
Hi,
Inline table is a table which loads in the QVW application created and maintain in application and we are able to create a QVD of this inline tables it is used to create when there is small amount of data we have.
You are able to create a table like this also
Temp:
LOAD * INLINE
[
zip_code
123456789
112233445
111222333
];
Main:
load
*,
left(zip_code,5) as zip5,
right(zip_code,4) as zip6
Resident Temp;
Drop Table Temp;
HTH
Regards,
Anand
Hi Shree,
I understood the concept but still one more doubt about what is meaning of "resident tmp" and why we use the syntax like this. As per the previous explanation
ZipTable:
LOAD *,
left(zip_code,5) as zip5,
right(zip_code,4) as zip4
INLINE [
zip_code
123456789
112233445
111222333
];
this works fine.
I think these are some very basic doubts but till now i don't know the answer.
Thanks,
Sujeet
Hi,
Resident tmp; is used for creating table from tmp table. And resident is used if data should be loaded from a previously loaded input table.
Regards,
Anand
Resident always refer to a previously loaded table.
if you want to make use of the existing table we go for resident .
remember that table should alwasy exists before using resident...