Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

DBOutputBulk Component not returning the columns in the Schema

Hello,

 

I'm dealing with MSSQLDBInput Component connected too a MSSQLDBOutputBulk component. My output is only returning the first column in my output. Not the second column (CodeDescription) which I have in my DBOutputBulk Schema.

 

Can anyone see any issues that would be causing the outputbulk component to not include both fields I have listed in SS?

 

My MSSQLDBInput has the following query

 

"DECLARE @ApprovedClients AS TABLE (
ClientID NVARCHAR(10)
)

INSERT INTO @ApprovedClients VALUES
--Initial Go Live
('703'),('314'),('323'),
--TSA South --DEV ONLY: Added 2/28/19
('700'),('701'),('702'),('703'),('704'),('705'),('725'),
('726'),('727'),('728'),('729')


--TSM_DonorType_CCYYMMDD.TXT
SELECT DISTINCT
'000' + ClientID + [NewCode] AS CodeKey
,[CodeDescription]
FROM [YLM_Stage].[dbo].[MAP_OrganizationCodes]
CROSS APPLY @ApprovedClients
WHERE [YLM_InputFile] = 'Donor'
AND [FieldName] = 'Type'
ORDER BY 1,2"

0683p000009M2i3.png

0683p000009M2i8.png

 

0683p000009M2hB.png

Labels (2)
1 Reply
Anonymous
Not applicable
Author

Hi,

 

   In your previous post, you have mentioned that you are running insert statements through tMSSQLDBInput. You are running lot of DB statements in a single tDBInput. Could you please add one select statement only per tDBInput and then join the tables using a tMap?

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂