Data view should be in good in QVD

[manoranjan_d]

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

[manoranjan_d]

when import the qvd any thing can be done?

[manoranjan_d]

no reply for this

[manoranjan_d]

22 pepole view but no reply

[Clever_Anjos]

Would you mind sharing your script?

[Anonymous]

Share the script, how you get that qvd?

[manoranjan_d]

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

[manoranjan_d]

i shared

[Clever_Anjos]

Please attach the real script...