Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem in Concatenate two qvds

Hi Friends,

I've Problem to Concatenate two qvds in attachment.

Please Help me.

3 Replies
Not applicable
Author

You have used qualify. Try and add unqualify *; to the top of the second tab, i.e.

2013-11-17_14h13_25.png

Fields are only merged during table concatenation if they have the same name. In your case most of the fields are unique because they are preceded by the table name.

Not applicable
Author

Thanks , but

after concatenating of two qvds , values of 2th qvd (Moojodi-Aval-Dore92.QtyNew) is wrong . ( values are "0" after expanding ).

preminqlik
Specialist II
Specialist II

hi here is the thing is after your string connection in the startingof the script you have written QUALIFY statement , here it is QUALIFYING whole script ....

please see the attahment ..