Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi my qvd shows the data which is not in proper alignments , so when i call the qvd in to table in design i m facing below issue.
example:
output is
issue:
Name | dept | coll | area | roll num | name2 | dept |
manoj | it | xxx | India | 1 | ||
siva | cse | xxx | America | 2 | ||
raju | it | xxx | India | 3 | ||
arun | cse | xxx | America | 4 | ||
vishal | it | xxx | India | 5 | ||
yaso | cse | xxx | America | 6 | ||
manoj | 2nd year | |||||
siva | 3rd year | |||||
raju | 4th year | |||||
arun | 5 year | |||||
vishal | 6 year | |||||
yaso | 7 year |
actuall output should has to be below :
Name | dept | coll | area | roll num | name2 | dept |
manoj | it | xxx | India | 1 | manoj | 2nd year |
siva | cse | xxx | America | 2 | siva | 3rd year |
raju | it | xxx | India | 3 | raju | 4th year |
arun | cse | xxx | America | 4 | arun | 5 year |
vishal | it | xxx | India | 5 | vishal | 6 year |
yaso | cse | xxx | America | 6 | yaso | 7 year |
when import the qvd any thing can be done?
no reply for this
22 pepole view but no reply
Would you mind sharing your script?
Share the script, how you get that qvd?
the actual requirement if Name is matching to name2 and dept not matching to dept1 means
it should show the name dept coll, area roll num,name2, dept1
file1:
load
Name,
dept,
coll,
area,
roll num,
name2,
dept1
from(xxxx)
where Exists(name2,Name)and not Exists(dept1,dept) ;
store into qvd
so above code will display name2 and dept1 as blank. to get the value of name2 and dept1 again i m doing the same step but changed the field of exists and not exists
file1:
load
Name,
dept,
coll,
area,
roll num,
name2,
dept1
from(xxxx)
where Exists(Name,name2)and not Exists(dept,dept1) ;
store into qvd
above code will display the value of name2 and dept1 so remaining field will be blank.
and then what i doing is
concanate both the qvd to get the exact output but the output shows the separated lines as
Name | dept | coll | area | roll num | name2 | dept |
manoj | it | xxx | India | 1 | ||
siva | cse | xxx | America | 2 | ||
raju | it | xxx | India | 3 | ||
arun | cse | xxx | America | 4 | ||
vishal | it | xxx | India | 5 | ||
yaso | cse | xxx | America | 6 | ||
manoj | 2nd year | |||||
siva | 3rd year | |||||
raju | 4th year | |||||
arun | 5 year | |||||
vishal | 6 year | |||||
yaso | 7 year |
so i need the exact outout as:
Name | dept | coll | area | roll num | name2 | dept |
manoj | it | xxx | India | 1 | manoj | 2nd year |
siva | cse | xxx | America | 2 | siva | 3rd year |
raju | it | xxx | India | 3 | raju | 4th year |
arun | cse | xxx | America | 4 | arun | 5 year |
vishal | it | xxx | India | 5 | vishal | 6 year |
yaso | cse | xxx | America | 6 | yaso | 7 year |
i shared
Please attach the real script...