topic Re: Not able to extract the picklist field value by using tfileoutput component in Talend Studio

Not able to extract the picklist field value by using tfileoutput component

Priyank2 — Fri, 15 Nov 2024 21:45:24 GMT

Hi,

I am not able to extract the picklist type field value in a .csv file by using tfileoutput delimited component,

I have already checked all field mapping and used the data type as a string.

Re: Not able to extract the picklist field value by using tfileoutput component

Anonymous — Tue, 30 May 2023 01:20:38 GMT

Hello @Priyank Jain ,

Could you please provide the .csv file content which include the picklist type values for more investigation?

Best regards

Aiming

Re: Not able to extract the picklist field value by using tfileoutput component

Priyank2 — Tue, 30 May 2023 04:23:40 GMT

Hello @Aiming Chen ,

Thanks for replying.

The field contains only two values which are 'Yes' and 'No', the value is also showing in the Talend screen by using the tlogRow component, but not extracted in a .csv file.

Thanks & Regards,

Priyank

Re: Not able to extract the picklist field value by using tfileoutput component

Anonymous — Tue, 30 May 2023 06:18:03 GMT

Hello @Priyank Jain ,

To load the csv file, please use the component tFileInputDelimited

here is an example, see https://help.talend.com/r/en-US/8.0/data-privacy/using-tfileinputdelimited-to-load-data

for usage of this component, please refer to https://help.talend.com/r/en-US/8.0/delimited/tfileinputdelimited-standard-properties

Thanks

Aiming

Re: Not able to extract the picklist field value by using tfileoutput component

Anonymous — Wed, 31 May 2023 10:04:54 GMT

Hello @Priyank

We see you've raised a support case in support portal for your issue as our talend support team is unable to see anything in the job export you shared. Could you please ensure you took the job export with all dependencies check box checked?

Best regards

Sabrina

Re: Not able to extract the picklist field value by using tfileoutput component

Priyank2 — Wed, 31 May 2023 16:24:49 GMT

Hello,

Yes i have shared the job export with all dependencies check box checked.

Thanks!