User Activity

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 So...
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 col...
Hi Team, I need to convert the values present in an array with comma separated into different columns. Not sure how to use pivot snap for this logic, can someone help me with the same?