topic Re: Different datatypes {Simple Select, Multiselect, Dropdown} for a field in Talend Target in Talend Studio

Different datatypes {Simple Select, Multiselect, Dropdown} for a field in Talend Target

SSharma1993 — Fri, 15 Nov 2024 22:50:33 GMT

Hi,

Please help in below scenario to have below datatypes through Talend. Is it possible?

Logic# 1:

If spec value contains [one] value and is [Yes, Y, True,…],

Create [Boolean] and check off [Yes] on Output

If spec value contains [one] value and is [No, N, false,…]

Create [Boolean] and check off [No] on Output

Logic # 2:

If spec value contains [two] value

Create [Simple Select] and list two values on

Output

Logic # 3:

If spec value contains [three or more] value

Create [Multi Select] and list values on

Output

Logic # 4:

If spec value contains [one] value and is [numeric],

Create [Number] on

Output

Logic# 5: catch all logic

If spec value does not fall under above logic,

Create [Text] on

Output

Remaining logic to be defined: Metric, Identifier

Re: Different datatypes {Simple Select, Multiselect, Dropdown} for a field in Talend Target

SSharma1993 — Mon, 13 Jun 2022 07:04:23 GMT

Can someone please help in this issue if we can have multiple datatypes for a field w.r.t incoming data i.e. Simple Select, Multi Select, Boolean, Numeric, Dropdown etc. type datatypes for a field in Talend.

Re: Different datatypes {Simple Select, Multiselect, Dropdown} for a field in Talend Target

Anonymous — Mon, 13 Jun 2022 09:33:38 GMT

What is your target application? It sounds like a UI development question rather than ETL question.

Regards

Shong

Re: Different datatypes {Simple Select, Multiselect, Dropdown} for a field in Talend Target

SSharma1993 — Mon, 13 Jun 2022 09:36:08 GMT

Thanks for your reply.

Target is RESTAPI. Through RESTAPI I have to send data to external systems which is you are right - a UI.

Re: Different datatypes {Simple Select, Multiselect, Dropdown} for a field in Talend Target

SSharma1993 — Mon, 13 Jun 2022 09:37:38 GMT

SaaS version where we have been provided with RESTAPIs to push data in the desired format but I am confused if these datatypes are gettable in Talend or not.

Could you please help!