https://community.qlik.com/t5/Talend-Studio/Nested-Multi-criteria-mapping/m-p/2233469#M23124 thanks for this, would it also be used by operational support to adjust calculations when a client decides to change the origin data without giving us appropriate notice? I just want to make sure it also has a life as an administration tool to the mapping as well as the creator of it. Thanks Tue, 05 Nov 2019 19:08:16 GMT Anonymous 2019-11-05T19:08:16Z https://community.qlik.com/t5/Talend-Studio/Nested-Multi-criteria-mapping/m-p/2233461#M23116 <P>Hi,</P> <P>I'm new to Talend Studio for Data Integration and am trying to understand how to manage a set of references which can be managed in a data source used in a transformation. I have another post in here because I don't have tStandardizeRow in my palette and cannot seem to find out how to install it if it is the right tool for the job.</P> <P>&nbsp;</P> <P>What I want to set the value of "Asset" based upon a series of one or more conditions. If I wrote it as an IF THEN ELSE set of steps, it would look like this:</P> <P>&nbsp;</P> <TABLE> <TBODY> <TR> <TD><P>IF origin.Instrument Type</P><P>equals 'Future'</P></TD> <TD><P>Set&nbsp;<EM>VALUE</EM><SPAN>&nbsp;</SPAN>to destination.Asset</P><P>VALUE = 'General Future'</P></TD> <TD><P>ELSE Set&nbsp;<EM>VALUE</EM><SPAN>&nbsp;</SPAN>to destination.Asset</P><P>VALUE = 'General Equity'</P></TD> </TR> <TR> <TD><P>IF origin.Instrument Type</P><P>equals 'Option'</P></TD> <TD><P>Set&nbsp;<EM>VALUE</EM><SPAN>&nbsp;</SPAN>to destination.Asset</P><P>VALUE = 'General Option'</P></TD> </TR> <TR> <TD><P>IF origin.Instrument Type</P><P>equals ('Equity' OR 'Warrant')</P><P>AND origin.Custodian Account Display Name</P><P>equals 'CFD'</P></TD> <TD><P>Set&nbsp;<EM>VALUE</EM><SPAN>&nbsp;</SPAN>to destination.Asset</P><P>VALUE = 'Equity'</P></TD> </TR> <TR> <TD><P>IF origin.Instrument Type</P><P>equals 'Bond'</P><P>AND origin.Custodian Account Display Name</P><P>equals 'CFD'</P></TD> <TD><P>Set&nbsp;<EM>VALUE</EM><SPAN>&nbsp;</SPAN>to destination.Asset</P><P>VALUE = 'Fixed Income'</P></TD> </TR> <TR> <TD><P>IF origin.Instrument Type</P><P>equals 'Credit Default Swaption'</P><P>AND origin.Custodian Account Display Name</P><P>equals 'CFD'</P></TD> <TD><P>Set&nbsp;<EM>VALUE</EM><SPAN>&nbsp;</SPAN>to destination.Asset</P><P>VALUE = 'Swaption'</P></TD> </TR> <TR> <TD><P>IF origin.Instrument Type</P><P>equals 'Interest Rate Swap'</P></TD> <TD><P>Set&nbsp;<EM>VALUE</EM><SPAN>&nbsp;</SPAN>to destination.Asset</P><P>VALUE = 'IRS'</P></TD> </TR> <TR> <TD><P>IF origin.Instrument Type</P><P>equals 'CDS'</P></TD> <TD><P>Set&nbsp;<EM>VALUE</EM><SPAN>&nbsp;</SPAN>to destination.Asset</P><P>VALUE = 'CDS'</P></TD> </TR> <TR> <TD><P>IF origin.Instrument Type</P><P>equals 'Repurchase Agreement'</P></TD> <TD><P>Set&nbsp;<EM>VALUE</EM><SPAN>&nbsp;</SPAN>to destination.Asset</P><P>VALUE = 'Repo'</P></TD> </TR> </TBODY> </TABLE> Sat, 16 Nov 2024 04:11:56 GMT https://community.qlik.com/t5/Talend-Studio/Nested-Multi-criteria-mapping/m-p/2233461#M23116 Anonymous 2024-11-16T04:11:56Z https://community.qlik.com/t5/Talend-Studio/Nested-Multi-criteria-mapping/m-p/2233462#M23117 <P>Hi,</P> <P>&nbsp;</P> <P>&nbsp; &nbsp; Could you please try tMap (use condition expressions) or tJavaRow (where you can write Java if-else conditions) to resolve your use case?</P> <P>&nbsp;</P> <P>Warm Regards,<BR />Nikhil Thampi</P> <P>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</P> Fri, 01 Nov 2019 17:07:00 GMT https://community.qlik.com/t5/Talend-Studio/Nested-Multi-criteria-mapping/m-p/2233462#M23117 Anonymous 2019-11-01T17:07:00Z https://community.qlik.com/t5/Talend-Studio/Nested-Multi-criteria-mapping/m-p/2233463#M23118 <P>Thanks for your response, I wanted to try to achieve this without codes using reference or rules data and apply one or more rules to a value in the mapping. If I end up adding Java into the mapping then the references themselves cannot be managed outside of the map by non-technical business users. How would you approach this without hard-coding rules and values?</P> <P>&nbsp;</P> <P>Thanks, Matt</P> Sun, 03 Nov 2019 19:10:19 GMT https://community.qlik.com/t5/Talend-Studio/Nested-Multi-criteria-mapping/m-p/2233463#M23118 Anonymous 2019-11-03T19:10:19Z https://community.qlik.com/t5/Talend-Studio/Nested-Multi-criteria-mapping/m-p/2233464#M23119 Is there a better way of doing a series of conditions with alternative actions using the paid version of Talend vs Open Studio? tStandardizeRow sounds interesting but might only be for specific data payload types for addresses, phone numbers, etc - I don't have that feature available on Open Studio so not entirely sure. Thanks, Matt Mon, 04 Nov 2019 19:21:08 GMT https://community.qlik.com/t5/Talend-Studio/Nested-Multi-criteria-mapping/m-p/2233464#M23119 Anonymous 2019-11-04T19:21:08Z https://community.qlik.com/t5/Talend-Studio/Nested-Multi-criteria-mapping/m-p/2233465#M23120 <P>Most of your conditions center around mapping Instrument Type to a desired Asset value. Some of the conditions don't appear to be fully covered. (ex: What happens if the Instrument Type is Bond and the Custodian Account Display Name is not CFD?)</P> <P>I would probably approach this as a lookup table, stored either in a database or a file that maps Instrument Types to their corresponding Asset values. I would apply the lookup regardless of conditions on the Custodian Account Display Name and simplify the conditional to use the lookup value or some replacement value.</P> <P>If you want to avoid checking the value of CADN in the code at all, then you can either include all the CADN values in the lookup table or else just the mappings when CADN = 'CFD' and != 'CFD'.</P> <P>Ex:</P> <PRE>Instrument Type CADN Asset ====================================== Future General Future Option General Option Equity CFD Equity Equity Other Bond CFD Fixed Income Bond CFD Other<BR />DEFAULT DEFAULT VALUE etc.</PRE> <P>This would allow changes to the mappings without needing to update the Talend job.&nbsp; You might need to apply the mappings more than once, and might need a special routine to handle and apply the default value for cases not handled by the rest of the mapping table.</P> Mon, 04 Nov 2019 20:17:13 GMT https://community.qlik.com/t5/Talend-Studio/Nested-Multi-criteria-mapping/m-p/2233465#M23120 cterenzi 2019-11-04T20:17:13Z https://community.qlik.com/t5/Talend-Studio/Nested-Multi-criteria-mapping/m-p/2233466#M23121 Thanks for this - yes, this is more like it. There is an ELSE action in that table which is to set value to General Equity - far right column. <BR />I was looking to do a lookup table as well but couldn't figure out how you would enter a lookup to file to resolve the value required and how I could incorporate it so that, if no match, THEN set value to General Equity. Mon, 04 Nov 2019 20:22:42 GMT https://community.qlik.com/t5/Talend-Studio/Nested-Multi-criteria-mapping/m-p/2233466#M23121 Anonymous 2019-11-04T20:22:42Z https://community.qlik.com/t5/Talend-Studio/Nested-Multi-criteria-mapping/m-p/2233467#M23122 additionally, the 'CFD' is a CONTAINS within string rather than EQUALS, which I cannot find a function to use in an expression for. I was going to have the table with explicit rows so have a resolve for: <BR /> <BR />1. Instrument Type equals x ANDCADN contains 'CFD' <BR />2. Instrument Type equals x AND CADN does not contain 'CFD' <BR /> <BR />Thanks, Matt Mon, 04 Nov 2019 20:25:32 GMT https://community.qlik.com/t5/Talend-Studio/Nested-Multi-criteria-mapping/m-p/2233467#M23122 Anonymous 2019-11-04T20:25:32Z https://community.qlik.com/t5/Talend-Studio/Nested-Multi-criteria-mapping/m-p/2233468#M23123 <P>Hi,</P> <P>&nbsp;</P> <P>&nbsp; &nbsp; If your use case is related to creation validation rules by business users themselves, one approach will be to provide Talend Data Prepartion tool for the business users. They can create all the data quality use cases themselves since the Talend Data preparation allows the business rules creation like a smart excel sheet.</P> <P>&nbsp;</P> <P>&nbsp; &nbsp; Once they create the Rules using Talend Data Preparation, you can use those recipes within Talend Studio by connecting to those recipes. Then you can implement these rules for production loads.</P> <P>&nbsp;</P> <P><A href="https://www.talend.com/resources/what-is-data-preparation/" target="_blank" rel="nofollow noopener noreferrer">https://www.talend.com/resources/what-is-data-preparation/</A></P> <P>&nbsp;</P> <P>Warm Regards,<BR />Nikhil Thampi</P> <P>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</P> Tue, 05 Nov 2019 05:08:51 GMT https://community.qlik.com/t5/Talend-Studio/Nested-Multi-criteria-mapping/m-p/2233468#M23123 Anonymous 2019-11-05T05:08:51Z https://community.qlik.com/t5/Talend-Studio/Nested-Multi-criteria-mapping/m-p/2233469#M23124 thanks for this, would it also be used by operational support to adjust calculations when a client decides to change the origin data without giving us appropriate notice? I just want to make sure it also has a life as an administration tool to the mapping as well as the creator of it. Thanks Tue, 05 Nov 2019 19:08:16 GMT https://community.qlik.com/t5/Talend-Studio/Nested-Multi-criteria-mapping/m-p/2233469#M23124 Anonymous 2019-11-05T19:08:16Z