Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to save different different table name into the one qvd file. Can anybody will help me to do this?
Example:
A:
Load Col1,col2 from abc.csv;
B:
Load col3,col4 from xyz.csv ;
Can i Store Like this: Store A,B into AB.qvd;???
Best Regards,
I don't think So...
If u want to save data from two tables into a single qvd then u need to either concatenate them or join them and then give a single Table name.
If its really necessary for u then try this:
abc:
Load
Col(1),
Col(2),
'a' as junk
from table a.csv;
Concatenate / / or Left Join
Load
Col(3),
Col(4),
'a' as junk
from table b.csv;
Store abc into abc.qvd;
Shubham Kumar, As far as i know. It is not possible.
One approach would be concatenating both tables in to one table with external field to identify the table while retrieving like
A:
Load Col1,col2,'Table A' as Table from abc.csv;
Concatenate
Load col3,col4,'Table b' as Table from xyz.csv ;
Store A into AB.qvd;
While loading this AB.QVd you can use this Table Flag to segregate the table A & B.(But This is not the advisable Way to store data).
If you can explain us your business logic, then we could think about better solution
Hi Shubham,
you can use a concatenated Load to achive this task. I would suggest to add a source-tag for each table/source.
A:
Load Col1,col2, 'abc.csv' as Source from abc.csv;
B:
Concatenate Load col3,col4, 'xyz.csv' as Source from xyz.csv ;
Store A into AB.qvd;
Not possible until you use Join or Concatenate to make it a single QV table.