Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to write Resident load in Binary load Qvw

Hi Experts,

My source is CSV file and my Qvw Is Binary load

my bainary qvw is BINARY DataMart.qvw

temp:

laod * ,

sector(Subfield ,',') as Sector

Resident Data;

Drop table Data;

But i am not getting the temp Data.

Thanks,

NAgarjuna k

4 Replies
Anil_Babu_Samineni

May be Maintain NoConcatenate for that ??

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

NoConcatenate is not working

Anil_Babu_Samineni

First remove this line

Drop table Data;

And check how DM looks like?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

This is not a valid statement:

sector(Subfield ,',') as Sector


Can you post your actual script?


-Rob