Precy
New Contributor
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Need to do lookup on multiple tables without using join
I will give you an example how i want the result as, From my input i have 2 fields assettype and ITEMSETID on which i need to do cross reference. I will have the 2nlookup tables merged as below: How can i achieve target_column for corresponding attributes when i do lookup on source column without using 2 joins.2.6KViews0likes0CommentsNeed to do lookup on multiple tables without using join
I have 30 tables to lookup on 30 respective columns, In case of other ETL tool we had lookup as a function to do it independently in a single transform. In snaplogic, I am not sure how to do it. I can combine all 30 into a single lookup table like Soure_column, Target_Column, Lookup field But again, if I use this in sql server lookup, and return Target_column as output field for each 30 cross refrence its working as and operator and giving me null. Can someone help me with how I can crack this in a simple way, since I do not want to do 30 joins.3.9KViews0likes3CommentsRe: Need help to generate json format as per maximo target requirement
When i tried with below logic i get output as follow: jsonPath($.mapValues((value, key) => { ALNVALUE: parseFloat(value) || value, ASSETSTTRID:key}), “$*”) which is not completely correct, i want highlighted assetnum, siteid, classstructureid outside the json path as mentioned in mapper snap. Seems like i am missing somewhere a bit.1.9KViews0likes0CommentsNeed help to generate json format as per maximo target requirement
I have an input in below format: which i need to transform into a json structure like below in order to load the asset to maximo, where highlighted ones are part of column list in input file and its corresponding value is to be saved in ALNVALUE column I am not sure how to achieve this, can somebody help me with this?2.4KViews0likes2CommentsRe: Transpose array row to columns
Let me give you in detail my requirement. Below is the input where input present in ASSETATTRID array to be transposed as columns which is working, and input present in VALUE array to be distributed as a value to respective transposed columns. I need the output as follow:3.1KViews0likes1CommentRe: Transpose array row to columns
Thanks @Spiro_Taleski, That worked like a piece of cake. Now i want to place the input present in Value array to the transposed column respectively. I tried $ASSETATTRID.toObject(x => x, x =>( $VALUE.toObject(x => x))), but not working as expected. When we have any input like [null,‘test’,null,…]3.1KViews0likes0Comments